Using ROW_NUMBER() to paginate your data with SQL Server 2005

With the release of SQL Server 2005 Microsoft introduces the long overdue ROW_NUMBER() function to solve this problem.
In this article Jason Witty will walk through a C# implementation of pagination using the ROW_NUMBER() method.