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

3 votes359 views1 answer
MySQL DELETE JOIN
SQL
6 votes393 views2 answers
Subtr Oracle ?
SQL
0 vote356 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
0 vote353 views1 answer
Azure sql server check foreign key
SQL
0 vote329 views1 answer
Power query datetime to date
SQL
0 vote359 views1 answer
How to create a table based on another table in mysql
SQL
0 vote446 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote369 views1 answer
Spark sql convert string to date
SQL
15 votes366 views4 answers
Export mysql db using command line
SQL
1 vote323 views1 answer
Mysql select row with max value group by
SQL