GilaMonster (4/7/2011)

---

If builtin\Admins is a login and sysadmin, all local and domain admins are sysadmin. Remove it, just make sure you have another administrative login first.

If it makes you feel...

Wow! Thx for the summary. I didn't how "bad" it was.

What makes me nervous is that we are planning to migrate all of these servers into...

I just dropped a clustered PK on a table (without nonclustereds) last week and it did not drop the whole table. Are you sure about this? I guess...

Thx. Out of curiosity, can I ask why they get rebuilt 3X? I assume one is when readd the PK it will rebuild them and then in my...

Thanks - much appreciated - and I'll check it out...

Sorry - what's an ST?

Remember I need to do a bulk operation, i.e. I need to be able to send things...

I want my refund.

Just kidding...

I need to be able to control batch and commti size as these are massive tables. If I know what you're talking about, these don't have that capability.

I think...

Nice!

Thank you.

We use McAfee and have a pretty intense system and haven't had any issues with it. The Win admins actually administer it - we just tell them what to...

Oops!

Did you try DBCC CleanTable out of curiousity?

poratips (6/2/2010)

---

Hi,

We are using Sql server 2005 and i would like to know some monitoring script so i can do some administration and maintenance like if disk get full and...

Okay, let me ask this in a more simple way:

Let's say you have a table with 20 partitions. Can you reinitialize just one of those partitions?

If not, how can...

Brandie Tarvin (5/12/2010)

---

You are not off base. I/O is basically reads & writes to the hard drive. If your disk controller went whooey recently or if there's another problem bottlenecking...