SQL Paging

Improve GridView Performance by Delegating Paging to SQL Server

November 13, 2010 by James H. Byrd

Use SQL Paging to make your grids so fast that you’ll wonder if you really clicked the mouse button.

Filed Under: Database Development, Microsoft SQL Server, Nerdy Musings Tagged With: GridView Performance, Microsoft C#.NET, Microsoft SQL Server, Programming Example, ROW_NUMBER SQL Function, SQL Paging, Transact-SQL