Calculate Execution and Cpu Time in SQL 2005/2008

By reading this blog you will know how to find out SQL Server parse and compile time of a SQL statement.

If we want to know cpu time and elapsed time of a sql statement then we have to SET STATISTICS TIME ON.
Just consider following example


SET STATISTICS TIME ON

Select * from TableName

-- Or Any Query

SET STATISTICS TIME OFF



Then it will show following output


SQL Server parse and compile time:
CPU time = 31 ms, elapsed time = 141 ms.