Measure the time it takes to execute a t-sql query
If you want a more accurate measurement than the answer above: set statistics time on — Query 1 goes here — Query 2 goes here set statistics time off The results will be in the Messages window. Update (2015-07-29): By popular request, I have written a code snippet that you can use to time an … Read more