By wrapping the query (or queries) to be tested in GETDATE() commands, you can estimate how long it takes for the tSQL to run. This form is
SELECT GETDATE()
-- Enter t-SQL to be tested here.
SELECT GETDATE()
GO
By wrapping the query (or queries) to be tested in GETDATE() commands, you can estimate how long it takes for the tSQL to run. This form is
SELECT GETDATE()
-- Enter t-SQL to be tested here.
SELECT GETDATE()
GO