Video Star
A common-enough practice to limit search results is to write paginated queries. You may give users the ability to specify how many rows per page they want to see, or you may have a set number of rows per page.
But the end goal is to allow users to very quickly get a smaller number of rows returned to them. Almost no one needs to get many thousands of rows back, unless they’re planning on exporting the data.
In these four videos, which are part of my paid training, I’ll teach you how to write reliably fast paging queries in SQL Server.
If you like this sort of stuff, head to the very end of my blog post for a discount code on all of my training.
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.
One thought on “The Art Of The SQL Server Stored Procedure: Pagination”
Comments are closed.