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

11 votes123 views2 answers
Turn off safe mode mysql
SQL
2 votes247 views5 answers
Unique in sql server
SQL
14 votes113 views3 answers
Trim sql
SQL
0 vote143 views1 answer
Gcloud sql instance list
SQL
0 vote120 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
16 votes115 views2 answers
Gremove folder from git
SQL
0 vote133 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote125 views1 answer
Postgresql not in alternative
SQL
1 vote361 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote118 views1 answer
Mysql date time string format python
SQL