Memory-Optimized Tables
SQL Server In-Memory OLTP helps improve performance of OLTP applications through efficient, memory-optimized data access, native compilation of business logic, and lock- and latch free algorithms. The In-Memory OLTP feature includes memory-optimized tables and table types, as well as native compilation of Transact-SQL stored procedures for efficient access to these tables.
For more information about memory-optimized tables, see:
Introduction to Memory-Optimized Tables
Details what memory-optimized tables are and provides information about data durability, accessing data in memory-optimized tables, and performance and scalability.
Native Compilation of Tables and Stored Procedures
Details how memory-optimized tables and natively compiled stored procedures are compiled into DLLs, and provides related security considerations.
Altering Memory-Optimized Tables
Guidelines for updating memory-optimized tables (including changing table columns, indexes, and bucket_count).
Understanding Transactions on Memory-Optimized Tables
This section provides several topics related to performing transactions on memory-optimized tables including transaction isolation levels, and cross-container transactions.
Application Pattern for Partitioning Memory-Optimized Tables
Detailed code sample that shows how to emulate partitioned tables when using memory-optimized tables.
Statistics for Memory-Optimized Tables
Details how statistics are compiled for memory-optimized tables and how to maintain and manually update statistics for memory-optimized tables.
-
Details the restrictions on supported collations and code pages for memory-optimized tables.
Table and Row Size in Memory-Optimized Tables
Details the 8060 byte limit on memory-optimized table rows, and provides an example for calculating table and row sizes.
A Guide to Query Processing for Memory-Optimized Tables
Provides an overview of query processing for both memory-optimized tables, and natively compiled stored procedures.