Pagination with OFFSET / FETCH : A better way

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