Table of Contents Introduction Building the Environment for Testing Paging rows with Limit Paging in SQL Server 2012 Comparing the Queries - ROW_NUMBER vs OFFSET/FETCH Conclusion References See Also Other Languages
One thing that keeps amazing me is how many smart developers still feel the urge to write their own data access layer (DAL). They either do it all manually, or they generate parts of it, or they generate the whole thing. Whichever way you go, there are still various alternative paths you can choose from.