This page intentionally left blank.

Jeff, make sure you go back and look at the code I posted again, as it has been revised. (Seth pointed out that I wasn't resetting the @timer.)...

Although I don't hail from NZ, I must be counted among the All Blacks' supporters.

I also root for the Essendon Bombers if I ever get a...

You're welcome, new Jeff. But by all means, make note of the subquery solution as well. As I finally conceded, when your volumes...

I've posted here for a number of years now, and have taken my share of lumps too. I doubt the process is over. But here is also...

This is exactly why you DON'T want screen display time in the mix. It includes system processes that have nothing...

I can't argue with "It depends."

Lynn, I need a judgment call from an official:

Is the above a more polite way of saying...

Ahhhh :w00t:

You're absolutely right. The first SET @timer was OUTSIDE the while loop. My bad, and thanks for pointing that out, Seth. ...

Okay.... I knocked this out before taking off for lunch. Now anybody reading can satisfy themselves using Jonathan's measurement of time to execute, since he doesn't seem to think...

I wouldn't have offered the cte/row_number() solution at all if this was the T-SQL 2000 forum... because it wouldn't even compile. This is T-SQL(SS2K5). What...

And I'll take a helicopter over your hunter.

Next you get a sparrow missile to shoot down my helicopter.... 😉

Don't trust the workload estimations from the visual display of execution plans.

Look at the I/O stats for a clue as to...

True, and I used to code that way before better techniques were made available in 2005/2008. ...

1) It preserves information when there are ties. Showing only one row in the result set removes what could be relevant information. In fact the CTE query given will return...

;with cte as (select *,ROW_NUMBER() over(partition by vehicle order by dueHours) as seqID from @sample )

select *...