Paul White NZ (5/6/2010)
On the physical ordering thing, I would just add that individual rows on the page may not be in physical clustered index either - only the page offset array entries are guaranteed to be in logical and physical order.
Paul, could you elaborate a bit more on this? BTW, thanks for the great articles on APPLY and Server-Side Paging.
Hugo, thanks for a great question, learned something new again.