Also http://use-the-index-luke.com/sql/partial-results/fetch-next... for the actual keyset paging (aka the seek method) technique. Which gives a better explanation than the OP's article IMO.