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

2 votes162 views1 answer
Sqlite insert if not exists
SQL
25 votes155 views5 answers
Date in mysql
SQL
12 votes160 views4 answers
Psql command not found
SQL
0 vote180 views1 answer
000webhost database values insert
SQL
5 votes180 views1 answer
Migrate sql table another database
SQL
0 vote211 views1 answer
Select milliseconds mysql
SQL
0 vote205 views1 answer
Linux upload database to mysql
SQL
8 votes144 views1 answer
Ltrim sql
SQL
2 votes144 views1 answer
Get first n letter of department name in sql
SQL
1 vote164 views1 answer
How to get previous year from sysdate in oracle
SQL