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 vote215 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
1 vote195 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote204 views1 answer
Sql check if column exists
SQL
0 vote204 views1 answer
What is mysql_pconnect
SQL
1 vote213 views1 answer
Mysql select for update ejemplo
SQL
1 vote277 views1 answer
Size of all tables in a schema oracle
SQL
15 votes204 views2 answers
Sql order by multiple columns
SQL
0 vote203 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote160 views1 answer
Java spring boot connect to sql server
SQL
8 votes185 views1 answer
How to remove tables from postgresql
SQL