The Art Of The SQL Server Stored Procedure: Pagination

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

Someone still has to know enough SQL Server to keep the robots in check, and that’s what my training is for.



One thought on “The Art Of The SQL Server Stored Procedure: Pagination”

Comments are closed.