Try:

AND Col2 IN ('abc', 'something')

My guess is that the OR condition could result in a more complicated filter - Books Online only quotes examples using AND, IN and BETWEEN. If...

How damaged is the 2000 system? You can always start SQL Server in Single User Mode (from the command prompt: sqlservr.exe -m) to log in using an admin account...

It's not a dumb question. If you see a query that experienced 3000ms of CPU time, there are a few things to consider.

#1 - This query took...

I agree with Jeff - a trigger would be useful to calculate the amount next to each category. It comes down to how often you'll be calculating this value...

Each query has no idea how much percentage of the CPU was in use, and, given that a single query can run for minutes or hours, the average CPU used...

Also consider that you may have a large number of indexes that aren't fragmented, and don't require rebuilding. You may have a situation where you're washing (rebuilding) your already...

bteraberry (7/22/2010)

---

The Dixie Flatline (7/22/2010)

---

Try to find an online server for "Diplomacy". Similar in concept to Risk, but no luck is involved. Only one turn per...

The general rule is to never, ever, ever delete your transaction log. If you ever feel the need to do this, take a deep breath, and don't do it.

I...

Next time, please create a new thread for a new question.

There's nothing wrong with keeping your mdf and ldf on the same LUN IF there is little IO contention. ...

The T-SQL command executed by Management Studio when running this against SQL Server 2000 is:

EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 1

So, if you search the registry for the instance's settings,...

The main reason is that the system databases are in use. Consider the five standard system databases (I'm avoiding the distribution database used in replication).

1. Master - This is always...

I've got a Sony Vaio Z (VGN-Z48GD). Good points - battery life isn't bad. Two solid state disks, in a RAID-0 configuration are very nice (200 GB). ...

Adding to Roy's suggestion, you might consider marking your old filegroups as read-only once they are sufficiently old enough. This way, you'd only need to do the filegroup backup...

When you create an index ONLINE, you are creating a brand new structure, and the old structure is not affected until the new one is ready. Therefore, if you...

You can try creating a specific login onto the server for his domain account. This way, when he connects, the login will be specific to his account rather than...