Avoid Unnecessary Lookups when Using ROW_NUMBER for Paging

http://ift.tt/1yEtSoV

Improve your solution's performance

Eliminate unnecessary lookups to improve the performance of the typical solution for paging using row numbers.

read more

from SQL Server Pro http://ift.tt/1lGKtPv