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

0 vote183 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
-1 vote182 views2 answers
Create temporary table sql
SQL
1 vote176 views1 answer
Oracle list constraints
SQL
5 votes182 views1 answer
Oracle nls session
SQL
11 votes179 views4 answers
Update row in mysql
SQL
11 votes177 views4 answers
Round in sql
SQL
0 vote147 views1 answer
Ms sql unique
SQL
1 vote181 views1 answer
Oracle check table lock
SQL
0 vote305 views1 answer
Get first match in each group mysql query
SQL
1 vote185 views1 answer
Too many connections mysql
SQL