Time Your T-SQL Queries

Here’s a quick way to get some timing statistics on your T-SQL:

 
DBCC FREEPROCCACHE
GO
DBCC DROPCLEANBUFFERS
GO
SET STATISTICS TIME ON
GO
 
-- Insert your query here
 
SET STATISTICS TIME OFF
GO

After you run the statements in query analyzer, check the messages tab to see how it went.

This entry was posted in MS SQL Server. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *