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

25 votes273 views4 answers
Metadata
SQL
0 vote282 views1 answer
Postgresql cast as year and month from timestamp
SQL
0 vote302 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote295 views1 answer
Carbon mysql d m y to y-m-d
SQL
1 vote270 views1 answer
Mariadb case switch
SQL
0 vote231 views1 answer
Mysql find foreign key references
SQL
0 vote294 views1 answer
Postgresql like
SQL
2 votes242 views1 answer
Foreign key example in dbms
SQL
0 vote250 views1 answer
How to check replication lag in mySQL
SQL
0 vote348 views1 answer
What is common table expression in sql
SQL