.NET Daily

Recommended Resources

Popular Content

Tagsearch stored procedure


Fast SQL Server Stored Procedure with Filtering, Sorting and Paging

Posted on July 11th, 2017.

Even though there are dozens of articles out there which shows you how to do a Microsoft SQL Server stored procedure with filtering, sorting and paging, the execution time greatly differs between each approach. So I started to do some research in order to find the best approach out there. And I believe I found it on Aaron Bertrand...