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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability