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 vote206 views1 answer
Sql case sttement with set
SQL
0 vote205 views1 answer
Django mysqlclient connection string
SQL
3 votes200 views1 answer
Two select sql
SQL
17 votes227 views3 answers
Postgresql list users
SQL
7 votes211 views2 answers
N highest salary in sql
SQL
0 vote199 views1 answer
Pl sql join 3 tables
SQL
8 votes195 views2 answers
Mysql get first x characters
SQL
1 vote202 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote207 views1 answer
Group by join columns per table
SQL
0 vote216 views1 answer
Postgresql linux password
SQL