1) partitioning the table won't help, since the query at hand will still have to read all the data. Well, it could help a tiny bit if the partitions...

This is WAYYYY to open-ended a question. See here in BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/5530f484-5bc4-467c-ae50-d708dafb24d0.htm for the starting topic on SQL Server locking. There also is no default type of...

No queries to post, but I will add that the query optimizer was so modified between 2000 and 2005 that there were bound to be lots of regressive-performing situations. ...

In a hurry while at an airport, so I may have missed a few connections/items.

1) SANs do NOT always outperform DAS. Given equal spindles it can often be a...

Here is the bible on deadlock troubleshooting: http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Note that there are two continuations to that posting.

Do they even make RAID controllers WITHOUT write cache?? :w00t:

Thanks for the confirmation Gila, and the test script for it.

Gila, for posterity's sake, were you able to login as DAC when the trigger was preventing normal logins? This could be a very important tip to know, or a...

Well, to be honest, having to wade through a bunch of views/functions to find the source of a perf problem actually makes me MORE money since I bill by the...

1) 2 cpus (unless they are dual or quad core (NOT Hyperthreaded)) is a bit light to process that much RAM.

2) For I/O, there are some documents I recommend, but...

A few things I missed:

1) 2GB is definitely not enough ram for all things non-sql server-buffer memory. I would leave at least 6GB, and watch for paging to see...

1) I wasn't aware there was a SP4 for Win2k3

2) You should ABSOLUTELY, WITHOUT QUESTION purchase a 64 bit machine and install 64bit OS and SQL Server. There are...

On a side note, I personally despise views!! As a consultant they REALLY confound my efforts to examine/tune my client's queries!

Helmut Rothtauscher (4/10/2008)

I'm working on Performance Tuning problem on a machine with at the moment 3 Databases with a size of 25 GB, 40 GB and 70 GB, growing each...

While I and I am sure others have benefitted from the deviation into how to efficiently sample tables with identities on them, that isn't addressing the needs of the OP....