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 vote236 views1 answer
How to reset table in sql server
SQL
0 vote233 views1 answer
Drop all procedures sql server
SQL
0 vote279 views1 answer
Calculer pourcentage mysql
SQL
1 vote234 views1 answer
Show per page table in xampp
SQL
-1 vote221 views1 answer
How to use update trigger in sql
SQL
0 vote221 views1 answer
Mysql xampp reset root password
SQL
1 vote236 views1 answer
Sql server update column based on another table
SQL
1 vote270 views1 answer
Db.Database.SqlQuery
SQL
0 vote221 views1 answer
How to save data in database in mysql node
SQL
2 votes291 views1 answer
Sql compare strings
SQL