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

7 votes205 views3 answers
Foreign key oracle
SQL
0 vote186 views1 answer
Check index sql server
SQL
9 votes207 views1 answer
Oracle get table schema
SQL
0 vote207 views1 answer
Copy data from one postgres container to another
SQL
0 vote316 views1 answer
Sql insert exemplo
SQL
2 votes198 views2 answers
Mysql get time from datetime
SQL
0 vote189 views1 answer
Java input type sql date
SQL
0 vote198 views1 answer
Oracle sql generate list of days
SQL
0 vote218 views1 answer
Oracle insert single quote in string
SQL
1 vote208 views1 answer
How to open closed port mysql in ubuntu
SQL