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 votes151 views6 answers
DB::table('users')->get();
SQL
0 vote173 views2 answers
Search stored procedures by name
SQL
0 vote149 views1 answer
Sql server beginning of month
SQL
0 vote134 views1 answer
Sql inserted
SQL
1 vote153 views1 answer
Add current timestamp in mysql
SQL
0 vote150 views1 answer
Sql query to get column names and data types in sql server
SQL
4 votes143 views2 answers
Mysql delete user if exists
SQL
4 votes169 views2 answers
Postgresql float data type
SQL
0 vote141 views1 answer
Watch mysql command line
SQL
0 vote151 views1 answer
Window function to forward fill
SQL