Fast Web paging in SQL Server 2005
December 15, 2006[From Builder.com]
Paging, the grouping together of records usually for display purposes, has never been easy to accomplish or very efficient in SQL Server. In the past, developers would have to design their stored procedures to accommodate paging using temp tables, or would have to return the entire result set back to the client and page the data set in that fashion. Neither method was very desirable from the point of view of the developer or the DBA.
The article continues at http://builder.com.com/5100-6388_14-6141785.html?tag=sc