title: SQL Server 2008 paging methods?
body: <p>I have to work with a potentially large list of records and I've been Googling for ways to avoid selecting the whole list, instead I want to let users select a page (like from 1 to 10) and display the records accordingly.</p>
  
  <p>Say, for 1000 records I will have 100 pages of 10 records each and the most recent 10 records will be displayed first then if the user click on page 5, it will show records from 41 to 50.</p>
  
  <p>Is it a good idea to add a row number to each record then query based on row number? Is there a better way of achieving the paging result without too much overhead?
  So far those methods as described here look the most promising:</p>
  
  <p><a href="http://developer.berlios.de/docman/display_doc.php?docid=739&amp;group_id=2899">http://developer.berlios.de/docman/display_doc.php?docid=739&amp;group_id=2899</a></p>
  
  <p><a href="http://www.codeproject.com/KB/aspnet/PagingLarge.aspx">http://www.codeproject.com/KB/aspnet/PagingLarge.aspx</a></p>