title: Efficient paging with large tables in sql 2008
body: <p>for tables with  > 1,000,000 rows and possibly many many more !</p>
  
  <p>haven't done any benchmarking myself so wanted to get the experts opinion.</p>
  
  <p>Looked at some articles on row_number() but it seems to have performance implications</p>
  
  <p>What are the other choices/alternatives ?</p>