Rather than getting a large record set from your database and paging through it in your application, you can use these techniques to do your paging on the SQL Server. This article shows a few ways to do paging in SQL and compares the performace of each technique...