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

6 votes298 views2 answers
Oracle
SQL
0 vote334 views1 answer
Postgres list tables and row counts
SQL
0 vote260 views1 answer
Select all domains of database firbird
SQL
1 vote268 views1 answer
Select random sample sql
SQL
0 vote272 views1 answer
Mysql group rows with same value
SQL
0 vote309 views1 answer
Oracle date winter time
SQL
0 vote299 views1 answer
Mysql where in keep order
SQL
0 vote286 views1 answer
Dnsmasq.conf location macos
SQL
0 vote288 views1 answer
Plpgsql if statement
SQL
0 vote281 views1 answer
Mysql command prompt date insert format
SQL