I ran the tests on my new server which is an HP DL380 G5 with 18 73GB SFF SAS drives (10 in an MSA50) - the internal 8 are on a P400 controller and...
You need to find out who is blocking who and why. I start with these queries: USE master GO --which processes are blocked SELECT * FROM...
I believe there would be no performance difference between the first two - either way you have 8 files on one RAID 10 array - the fact that the array...
Try an xp_stopmail - that might do it: http://support.microsoft.com/kb/555180/en-us otherwise, the SQL server service has to be restarted - I...
Definitely reindex only when necessary as Luis suggests Database growth during index rebuilds occurs as a result of all the reorganization getting...
The only thing I can suggest given all the unknowns is to create a simple test table and replicate it - assuming you can make it perform well with a...
I'm pretty sure global variable values don't persist between runs - if you set the value then save the package it persists, but if you set the value...
The following works in 2000: SELECT PROBLEMNAME, PROBLEMCOUNT , (select sum(PROBLEMCOUNT) from YourTable) as GrandTotal FROM YourTable t group by...
I'm replacing an existing server and have a few questions: 1) Sample configurations and recommendations start at 2 sockets - I think 1 proc is...
Separate names with a comma.
