How can I clear the SQL Server query cache?
Here is some good explaination. check out it. http://www.mssqltips.com/tip.asp?tip=1360 CHECKPOINT; GO DBCC DROPCLEANBUFFERS; GO From the linked article: If all of the performance testing is conducted in SQL Server the best approach may be to issue a CHECKPOINT and then issue the DBCC DROPCLEANBUFFERS command. Although the CHECKPOINT process is an automatic internal system process … Read more