I show how to use common table expressions (CTEs) to better optimize SQL Server pagination queries that use OFFSET / FETCH.