Don't forget to hunt down and torture the person that used quotes in column names.

No, I'm not the real Sergiy in disguise.

Object ID is database specific. You have to query the database in which the object resides.

Bear in mind that SQL Server will not consume 100% of the max memory you set if it does not need it. So it's not all that unusual that it...

I agree with everything that John said, but I just want to add one bit. I prefer to simply use RAID 10 for everything because it requires less planning if...

A high scan density is good. A perfect situation would be to have a scan density of 100. So if the indexes are in really good shape, then DBREINDEX is...

Logins and users are not the same thing. Logins are server level and users are database levels. A login is what gives soemone the ability to access the server. The...

Yes, just go into the services applet and change it. You can't connect because the service can't start.

Can't

One thing to note about using "CREATE CLUSTERED INDEX ... WITH DROP_EXISTING ON filegroupname" instead of "Alter Table ... Move To filegroupname" is that this moves the entire clustered index whereas Alter Table...

Well, thanks for agreeing with me.

My guess would be the connection string for the third DSN is using the wrong password or the wrong authentication type.

What you describe that you want to do is partitioning. The Alter command that I believe that you are thinking of is Alter Table ... Move To ... .

You can...

LOL Thanks!! That would probably cure my insomnia!!

What has doubled? The data file? The log file? Both?

My suspicion is that in all the attach/detach/reattach/restore panic, you only think it has doubled in size, but it hasn't.

What makes...

The easiest (and most evil) way to know when someone wants to drop or create a database in SQL 2000 is to deny drop database and create database permissions to...