Community

A More Efficient Method for Paging Through Large Result Sets

(Greg Hamilton) It is amazing the amount of cycles, hardware and brain ware, go into paging results efficiently. Recently Scott Mitchell authored an article titled Efficiently Paging Through Large Result Sets in SQL Server 2000 that looked at a stored procedure that returned a particular “page” of d

Read More - Register for Free Membership