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

1 vote167 views1 answer
Postgres set sequence value to max id
SQL
1 vote145 views1 answer
OSError: mysql_config not found
SQL
3 votes138 views1 answer
Increment integer in table sql
SQL
0 vote77 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
9 votes171 views3 answers
Pyodbc connect to sql server
SQL
0 vote118 views1 answer
Sql gather statistics to increase performance
SQL
2 votes166 views1 answer
Username sql
SQL
0 vote129 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote127 views3 answers
How to increase size of column in sql
SQL
2 votes116 views1 answer
Oracle sql day of month from date
SQL