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 vote126 views1 answer
Ms sql print more than 1 variable
SQL
1 vote304 views3 answers
Sql subquery
SQL
7 votes182 views2 answers
Show size database mysql
SQL
6 votes174 views2 answers
Database url postgres
SQL
1 vote197 views1 answer
Oracle get current schema
SQL
1 vote183 views1 answer
Sql list all procedures
SQL
1 vote184 views1 answer
Sql server 2012 query history
SQL
0 vote191 views1 answer
Placements hackerrank solution
SQL
4 votes180 views2 answers
Tsql utf to local time
SQL
0 vote196 views1 answer
Mysql query to select the highest value
SQL