Expert SQL server in-memory OLTP / Dmitri Korotkevitch.

At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Why In-Memory OLTP?; Background; In-Memory OLTP Engine Architecture; In-Memory OLTP and Other In-Memory Databases; Oracle; IBM DB2; SAP HANA; Summary; Chapter 2: In-Memory OLTP Objects; Preparing a Database to Use In-Memory OLTP; Creating Memory-Optimized Tables; Working with Memory-Optimized Tables; In-Memory OLTP in Action: Resolving Latch Contention; Summary; Chapter 3: Memory-Optimized Tables; Disk-Based vs. Memory-Optimized Tables

Introduction to Multiversion Concurrency ControlData Row Format; Native Compilation of Memory-Optimized Tables; Memory-Optimized Tables: Surface Area and Limitations; Supported Data Types; Table Features; Database-Level Limitations; High Availability Technologies Support; SQL Server 2016 Features Support; Summary; Chapter 4: Hash Indexes; Hashing Overview; Much Ado About Bucket Count; Bucket Count and Performance; Choosing the Right Bucket Count; Hash Indexes and SARGability; Statistics on Memory-Optimized Tables; Summary; Chapter 5: Nonclustered Indexes; Working with Nonclustered Indexes

Creating Nonclustered IndexesUsing Nonclustered Indexes; Nonclustered Index Internals; Bw-Tree Overview; Index Pages and Delta Records; Obtaining Information About Nonclustered Indexes; Index Design Considerations; Data Modification Overhead; Hash Indexes vs. Nonclustered Indexes; Summary; Chapter 6: Memory Consumers and Off-Row Storage; Varheaps; In-Row and Off-Row Storage; Performance Impact of Off-Row Storage; Summary; Chapter 7: Columnstore Indexes; Column-Based Storage Overview; Row-Based vs. Column-Based Storage; Columnstore Indexes Overview; Clustered Columnstore Indexes

Performance ConsiderationsColumnstore Indexes Limitations; Catalog and Data Management Views; sys.dm_db_column_store_row_group_physical_stats; sys.column_store_segments; sys.column_store_dictionaries; Summary; Chapter 8: Transaction Processing in In-Memory OLTP; ACID, Transaction Isolation Levels, and Concurrency Phenomena Overview; Transaction Isolation Levels in In-Memory OLTP; Cross-Container Transactions; Transaction Lifetime; Referential Integrity Enforcement; Summary; Chapter 9: In-Memory OLTP Programmability; Native Compilation Overview; Natively Compiled Modules

Natively Compiled Stored ProceduresNatively Compiled Triggers and User-Defined Functions; Supported T-SQL Features; Control Flow; Operators; Query Surface Area; Built-in Functions; Atomic Blocks; Optimization of Natively Compiled Modules; Interpreted T-SQL and Memory-Optimized Tables; Performance Comparison; Stored Procedures Performance; Scalar User-Defined Function Performance; Memory-Optimized Table Types and Variables; Summary; Chapter 10: Data Storage, Logging, and Recovery; Data Storage; Checkpoint Files States; PRECREATED State; UNDER CONSTRUCTION State and CHECKPOINT Process