SQL Benchmarking - Clear Cache

When benchmarking in SQL, it is important to clear the cache because SQL can store results. The following two commands clear the main cache and the stored procedure cache respectively.

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

Additional Interesting Articles

Block File Leechers Using PHP
C# Regular Expression Example
t-SQL Cursor
C# MailMessage Example
SQL Create Procedure
SQL Benchmarking - Clear Cache

©2008 AndrewKimball.com