Re-post: Pagination on SQL Server

Check out this article I wrote at work about performing paginated queries in SQL Server.

Pagination on SQL Server