Jake Shelton (3/19/2012)
I'm surprised at # 4 however, what database-level changes have you found most involved with improving performance?
AWE on 32 bit instances (instance not database level), max server memory (instance not database level), forced parameterisation, optimise for ad-hoc workloads (instance not database level), snapshot or read committed snapshot. Turning off autoclose/autoshrink, fixing growth increments, fixing log fragmentation.
Huge gap between 3 and 4 though, and most of those are not for SQL 2000
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass