Tag Info

New answers tagged


DATEDIFF will be useful DECLARE @StartTime1 datetime SET @StartTime1 = GETDATE() select query 1 SELECT ExecutionTimeInMS = DATEDIFF(millisecond, @StartTime1, getdate()) GO similarly do for other queries. @starttime2, 3


According to my understanding this first limit the number of records to 3 and then do a sequential scan for all the records. Why does this do a scan for all the records since it has already limited the result to 3 rows ? That's not (necessarily) what's happening. Outer nodes consume rows from inner nodes one by one with a demand-pull model. So in this ...

Top 50 recent answers are included