SentryOne Team Blog (blogs.sentryone.com)

Tag : pagination

Aaron Bertrand : Pagination with OFFSET / FETCH : A better way

Aaron Bertrand (@AaronBertrand) shows how to use common table expressions (CTEs) to better optimize SQL Server pagination queries that use OFFSET / FETCH.