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 vote128 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote104 views1 answer
Group_concat order by
SQL
0 vote124 views1 answer
Ubuntu connect to mssql database
SQL
58 votes262 views6 answers
Create new user in postgres
SQL
0 vote107 views1 answer
Mysql beautifier terminla
SQL
1 vote95 views1 answer
Oracle lock user
SQL
0 vote115 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote113 views1 answer
Tsql table column constraint must be uppercase
SQL
0 vote113 views1 answer
Create a sql server database programmatically
SQL
4 votes98 views1 answer
Mysql ip address
SQL