See the compile time

,

Change the database name, and insert your SQL statement(s), Function(s), or SPROC(s) in the middle.

 

use <mydatabase>
go

dbcc freeproccache
go
checkpoint
go

set statistics profile on
go
set statistics io on
go
set statistics time on
go
select 'starting time: '
select getdate()
go

<insert your SQL here>

go
select 'ending time: '
select getdate()
go
set statistics profile off
go
set statistics io off
go
set statistics time off
go

Rate

2.6 (5)

Share

Share

Rate

2.6 (5)