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 vote249 views1 answer
Mysql where don't have string
SQL
3 votes225 views1 answer
V$session not found in oracle
SQL
0 vote242 views1 answer
Get clob size oracle
SQL
0 vote232 views2 answers
Sql max count
SQL
0 vote241 views1 answer
Sql check for null and empty string
SQL
0 vote219 views1 answer
The local psql command could not be located
SQL
0 vote229 views1 answer
Fast sql column count
SQL
0 vote215 views1 answer
Postgresql regular expression special characters
SQL
0 vote225 views1 answer
Retornar apenas o ano mysql date
SQL
7 votes235 views1 answer
Return insert results in POSTGRESQL
SQL