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 vote128 views1 answer
Sql min
SQL
4 votes132 views2 answers
Mysql show indexes on table
SQL
10 votes141 views1 answer
Oracle dependencies table
SQL
8 votes148 views4 answers
Postgresql server restart
SQL
0 vote127 views1 answer
Mysql 1 hour ago
SQL
2 votes133 views2 answers
Set database timezone mysql
SQL
0 vote135 views1 answer
Prodection ready postgres database step by step
SQL
3 votes133 views2 answers
Df to sql pandas sql achemy
SQL
1 vote137 views2 answers
Sql server concat string and int
SQL
0 vote125 views1 answer
Rabbitmq service not starting
SQL