SQL Server Internals: In-Memory OLTP
Hekaton in-memory data is accessible, transparently, using familiar interfaces such as T-SQL and SSMS, but Hekaton's internal behavior and capabilities are very different than those of the standard relational engine. Everything you knew about how your SQL Server stores and accesses data is different in Hekaton. Everything you understood about how multiple concurrent processes are handled needs to be reconsidered.
In this book, Kalen Delaney explains how the new In-Memory OLTP engine works, how it stores and manipulates data, and how, even with all data stored in memory and no locking or latching, it can still guarantee the ACID properties of all transactions.
Kalen has been working with SQL Server since 1987, specializing in query performance tuning and SQL Server internals. The Hekaton internals knowledge she provides in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.
Table of contents
- What's Special About In-Memory OLTP?
- Creating and Accessing In-Memory OLTP Databases and Tables 35
- Row Structure and Multi-Versioning
- Indexes on Memory-Optimized Tables
- Transaction Processing
- Logging, Checkpoint, and Recovery
- Native Compilation of Tables and Native Modules
- SQL Server Support and Manageability
| Pages : | 201 |
| Size : | 12.5 MB |
| File type : | |
| Downloads: | 67 |
| Created: | 2022-02-03 |
| License: | For personal or educational use |
| Author(s): | Kalen Delaney |
Others related eBooks about SQL Server Internals: In-Memory OLTP
PostgreSQL Shell Commands free PDFDownload free course PostgreSQL Shell Commands free PDF, pdf file on 8 pages by tutorialkart.com....
SQL Server Backup and RestoreDownload free course SQL Server Backup and Restore, pdf file on 381 pages by Shawn McGehee....
MySQL Notes for ProfessionalsMySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this MySQL Notes for Professionals is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out exampl...
Access 2013 Lab manualDownload free Microsoft Office Access 2013 file under 115 pages,pdf manual , course tutorial training on pdf by David Murray (University at Buffalo)....
How to Install SQL Server 2008With this tutorial you will learn step by step how to install SQL Server 2008 and how to check the correct configuration of the server. Download free pdf training course in 32 page intended to beginners....
Microsoft SQL Server 2012This PDF tutorial will teachs you how to use SQL Server Data Tools to develop and deploy an Analysis Services project with examples,it's a free training course under 169 pages by Microsoft....
The Little MongoDB BookKarl Seguin is a developer with experience across various fields and technologies. He's an..., download free MongoDB tutorial in PDF (66 pages) created by ....
Introducing Microsoft SQL Server 2016Download free course Introducing Microsoft SQL Server 2016, pdf file on 215 pages by Stacia Varga, Denny Cherry, Joseph D'Antoni....
Protecting SQL Server DataDownload free course Protecting SQL Server Data, pdf file on 232 pages by John Magnabosco....
MySQL Notes for ProfessionalsDownload free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community....