TSQL Enhancements in SQL11 (SQL Server 2011 / Denali) to support Server Side Paging

Server Side Paging is a common scenario most application developers must have encountered while creating front end applications that requires paging support. Instead of returning all the rows from the database and implement paging at the client side, you might want to implement the paging on the server side so that only those rows needed for the current page are retrieved from the server. This