paging – Tarik Billa

Understanding Virtual Address, Virtual Memory and Paging

May 23, 2023 by Tarik

Before I answer your questions (I hope I do), here are a few introductory remarks: Remarks The problem here is that “virtual memory” has two senses. “Virtual memory” as a technical term used by low-level programmers has (almost) nothing to do with “virtual memory” as explained to consumers. In the technical sense, “virtual memory” is … Read more

Dapper. Paging

March 29, 2023 by Tarik

You didn’t specify a database or version. If you’re lucky enough to be able to use the brand new SQL Server 2012 and have access to MSDN, you can use the shiny new OFFSET and FETCH keywords. The following query will skip 20 records and return the next 5. SELECT * FROM [Posts] ORDER BY … Read more