jswong05 (11/14/2012)
You can also issue commands to clear buffer and procedure cache in server quiet time. (recommend you do so at maintenance window)
Correction. Recommend that you don't run such operations on a production server at all.
What's with all the thread necromancy lately?
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
We walk in the dark places no others will enter
We stand on the bridge and no one may pass