The past few chapters have focused on specialized indexing-related data types in SQL Server. SQL Server also offers specialized tables that reside in memory called memory-optimized, or in-memory, tables. Introduced in SQL Server 2014, these tables reside fully within memory while SQL Server is running relying on disk-based structures only for ensuring the ability to recover from service restarts.
With memory-optimized tables being primarily memory based, this has a significant impact on the traditional structures of a table and its indexes. In this chapter, you’ll ...
