Paging through lots of data with MS SQL Server 2005 and ASP.NET 2.0

This link explains how MS SQL Server 2005 supports paging in GridView (web control in ASP.NET 2.0) through "ROW_NUMBER() OVER (...)" function:

Paging through lots of data efficiently with ASP.NET 2.0

This is another article on the "SQL Pager" topic:
Returning Ranked Results with Microsoft SQL Server 2005
You can find here some nice stuff about Ranking SELECT's resultset.