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

2 votes318 views3 answers
3 days back in sql server
SQL
8 votes363 views3 answers
Postgres database sizes
SQL
0 vote318 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
2 votes337 views2 answers
How to check database username and password in postgresql
SQL
0 vote325 views2 answers
Sql searching via key word
SQL
0 vote346 views1 answer
The fetch keyword oracle
SQL
2 votes343 views1 answer
Oracle list duplicates
SQL
1 vote328 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote326 views1 answer
Datagrip go to line
SQL
0 vote336 views1 answer
SAP Return
SQL