1) Use Task Manager to see what process is actually doing the I/Os.

2) If you have win2k3, there are a number of bugs that will flush RAM (large file copy,...

1) Why don't you simply increase your timeout from 15 sec to 30, 60 or more seconds? keep you from losing customers until you get things optimized.

2) Since SQL...

I am going to go with Matt here in that on a very busy system with off-hours slow time full recovery mode can allow optimal performance during the peak time...

Here's the KB article for anyone interested: http://support.microsoft.com/kb/927396

I guess others have complained about the wrapping thing too. Just saw this very timely post:

http://www.sqlservercentral.com/articles/SQLServerCentral.com/61520/

I still think (very strongly) this should be fixed. Can we start a...

You know, you just GOTTA LOVE making single passes through the data. I have used that inline-variable update mechanism in the past to great effect. Almost like the...

noeld, did the entire sql server ram get flushed (I must admit it was pretty amazing seeing physical ram go from 9.2GB to 0 bytes instantaneously!! 🙂 or was it...

Lock Pages in Memory only applies to Enterprise Edition of SQL Server.

I had wondered about that too. Bet Itzik has something up his immense sleeve to super-charge this particular puzzle. 🙂

Hey, what the heck are you doing playing on the...

Having read this blog post recently: http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx, I decided to see if a cursor solution to this problem could be more efficient than the set-based one proposed. I...

Version upgrade shouldn't cause indexes to be lost (although you should compare current schema to a copy of the schema take prior to the upgrade). You DO have a...

What version of SQL Server? 32 or 64 bit? Was this just a hardware update or was software updated as well.

The OP asked what was faster. I was answering his/her question. And yes, I have used the approach I mention to achieve optimal performance in production systems. ...

MySpace uses SQL Service Broker to process tens of millions of messages per day so I can assure you that it is a viable solution for any asynchronous need you...

>>FYI, what I use it mostly for is a lookup table. For example, "gender" is stored as 1 or 2,

>>and the value that is displayed on the user's screen...