LOL Thankfully the queries being paged aren't quite as large as those you used to give my technique a beating. 😉

This is the right tool for me only because the paged result sets are fairly small, and the cost of the query that builds the resultset is what causes my customers to wait.

Your comments caused me to take another look at my procs, and the worst case scenario is elapsed time overhead in the tens of milliseconds. I, and my customers, can live with that.

I've submitted a minor revision to the article, suggesting that this approach is only beneficial in a narrow set of circumstances.