Testing SQL Code without cache - SQL Server
To find out how long a SQL query takes to run, you can't have the results already in the SQL Server cache.
To clear the SQL cache, enter:
DBCC DROPCLEANBUFFERS
If you are testing a stored procedure, clear the stored procedue cache by entering:
DBCC FREEPROCCACHE
Created By: amos 3/20/2006 12:13:01 AM
|
|