Tag: sql-server

SQL Server Pagination with COUNT(*) OVER() Window Function

January 30, 2026 · 5 min read

Stop running two queries for paginated results. Use COUNT(*) OVER() to get everything in one shot.