In SQL server we always found the running query in Seconds but we have never the seen the time in Milliseconds.
To find the time in Milliseconds we can use the following Syntax.
SYNTAX
SET STATISTICS TIME ON
T-SQL STATEMENT
SET STATISTICS TIME OFF
EXAMPLE
The following example i used the STATISTICS TIME ON & OFF statement to find the time take by the query in milliseconds.
In the message tab we can find the CPU time & Elapsed time in milliseconds as shown below.
No comments:
Post a Comment