SQL Server Paging

Paging with SQL Server has always been a pain. Although SQL Server 2005 introduced some features that made it possible to page results efficiently more easily than ever before.

Paging in SQL Server 2005 at 15 Seconds shows you how to do it with the new ROW_NUMBER() function.