Timing sql queries

DECLARE @t1 DATETIME;
DECLARE @t2 DATETIME;

SET @t1 = GETDATE();
SELECT /* query one */ 1 ;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

SET @t1 = GETDATE();
SELECT /* query two */ 2 ;
SET @t2 = GETDATE();
SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;

Timing sql queries

SELECT GETDATE();
SELECT /* query one */ 1 ;
SELECT GETDATE();
SELECT /* query two */ 2 ; 
SELECT GETDATE();

-1

Source: stackoverflow.com

Similar codes

6 votes128 views1 answer
Oracle trigger after logon on database
SQL
-1 vote138 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote140 views3 answers
CONTACT FORM SQL
SQL
1 vote119 views1 answer
Real world example of nosql
SQL
0 vote134 views2 answers
How to know the character set of an oracle databes
SQL
3 votes87 views4 answers
Show columns from table
SQL
0 vote146 views1 answer
Sub query in linq
SQL
0 vote137 views1 answer
How to update date value in sql
SQL
0 vote133 views1 answer
Double in sql server example
SQL
1 vote127 views1 answer
Mysqli connect
SQL