first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

T-SQL: Measuring How Long a Query Takes

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
mod date: 1999-02-09T19:35:15.000Z