Optimising Server-Side Paging - Part II
The second part of this series compares four methods of obtaining the total number of rows in a paged data set.
2010-05-24
18,855 reads
paging
Optimising Server-Side Paging - Part I
This article by Paul White presents an optimisation for paging through a wide data set.
2010-04-26
27,714 reads
Stored procedures to implement paging for large tables or queries in SQL Server 2005 and SQL Server 2008
A tip from MSSQLTips that shows a few ways for implementing paging on large tables.
2009-03-12
5,878 reads
Blogs
Chatting with Power BI: Who Benefits from This Conversation?
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
A Quick Look at Redgate Data Modeler
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Prepping for Certification, Part 2 of ?
By Brian Kelley
The advantage of understanding the make-up of the exam: I can tailor my efforts...
Forums
SQL Server 2025 Build List
Comments posted to this topic are about the item SQL Server 2025 Build List
Filtered Indexes: The Developer’s Secret Weapon in SQL Server
Comments posted to this topic are about the item Filtered Indexes: The Developer’s Secret...
Is Data Modeling Common?
Comments posted to this topic are about the item Is Data Modeling Common?
Question of the Day
Getting The Database Name
I run this code to connect to SQL Server 2022 from the command line.
sqlcmd -S localhost -EAt the command line, I run these two commands:
SELECT ORIGINAL_DB_NAME() GOWhat is returned? See possible answers