SQL Server Server-Side Paging

Server side paging of SQL 2008 result sets can be achieved using the following code:

DECLARE @start_row INT ,@end_row INT SET @start_row = 1 SET @end_row = 10 SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY a.updated_date ) AS row_num ,* FROM dbo.address a WHERE a.updated_date > '2012-02-13' ) AS r WHERE row_num >= @start_row AND row_num < @end_row ORDER BY row_num