MSSQL 2005: Paging with ROW_NUMBER is the fastest

Speaking about Paging in MSSQL - obviously Paging with ROW_NUMBER is the fastest paging for today. I just made some tests comparing it to Paging with ROWCOUNT and ROW_NUMBER is much faster. Tested on million rows. ROWCOUNT is also fast, the main query cost there goes for COUNT(*) but still. Also both ways do not depend on the page number - first and last pages have the same cost.

Related Posts:

• MSSQL: Managing Schema Changes on Large Tables
• The most important thing in SQL
• T-SQL: Get only Date from DateTime
• T-SQL: Date Ranges
• Date Processing - T-SQL or SQLCLR ?
• MSSQL Dynamic Management Views (DMVs) for indexes
• MSSQL 2005 System Tables Map
• MSSQL: How to migrate a database server
• MSSQL: Partitioning and Parallelism
• MSSQL 2005: Troubleshooting Performance methodology