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
15,616 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
23,914 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
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Using ChatGPT for Writing
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Forums
Validating Password Expiration
Comments posted to this topic are about the item Validating Password Expiration
Extracting multiple fields from one column
Hello, I have a situation. I am trying to show each distinct...
Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances
Comments posted to this topic are about the item Unlock the Power of Google...
Ask SSC