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

3 votes122 views1 answer
Query less than datetime sql
SQL
0 vote150 views1 answer
Sparql if bound query
SQL
0 vote119 views1 answer
Insert array into mysql column
SQL
0 vote121 views1 answer
PGSQL dynamic table name
SQL
0 vote125 views1 answer
Compression of dabatase mysqldumo
SQL
-1 vote116 views1 answer
Concat two columns in sql server
SQL
2 votes129 views1 answer
Wait delay in sql server
SQL
0 vote116 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote133 views1 answer
Primary key start from number
SQL
0 vote122 views1 answer
Get number of rows in every table mysql
SQL