One extra point - make sure ndf is in the AV exclude list too in case you have additional data files that use that extension.

http://support.microsoft.com/kb/KB920739

I agree with the post that states that if there isn't a huge concern for locking the best thing is to simply remove the temp table altogether and simply do...

Simon, I ALWAYS set the maximum memory SQL Server is allowed to grab. It can and does starve the OS for RAM on occassion.

I had to get the information for both bugs from a third-level sql server support staff at MS. The HP bug is so disasterous for the box that I...

I had a client that was spanked by BOTH of the bugs covered in this thread: HP iLO and Windows Large File Copy. Symptoms were the same for...

I agree Tim! Consider yourself to be VERY fortunate to have a DBA at all for SQL Server, much less one that enjoys writing TSQL. I do hope...

Gosh is that inefficient tho . . .

I sure hope you aren't moving to LAMP because you (or the powers that be) decided that SQL/IIS can't perform acceptably!!

Since you seem to be truly new to administering/monitoring/tuning sql server, I HIGHLY recommend you hire a performance consultant for a few hours to give your system the once over....

I count a max of 3 for any one sentence he wrote, and his average is <1. Whats the big deal?? 🙂

Man, this is a performance specialists wet dream!! 🙂

Hey, are you caching data on your webfarm?? You seriously need to limit your database activity in this scenario,...

One very important issue has gone unmentioned here. What is the distribution of the data for the index?? If you have some field that does not get values...

1) SQL 2000 Std can't use more than 2GB of ram, IIRC, so more memory won't help here.

2) that is truly a staggering number of connections in such a short...

in the index for BOL, type in "OPTION clause", without double quotes.