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 vote168 views4 answers
Mysql desactivar trigger
SQL
11 votes162 views1 answer
Oracle insert into where
SQL
0 vote233 views1 answer
Radius search with point data in mysql
SQL
1 vote167 views1 answer
Oracle explain plan
SQL
0 vote182 views1 answer
How to move a column to different spot mysql
SQL
-1 vote160 views1 answer
Plsql while
SQL
1 vote184 views2 answers
Begin transaction sql
SQL
-1 vote126 views1 answer
Mysql how to set update or create
SQL
0 vote217 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote205 views1 answer
Sparql if bound query
SQL