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: | 72 |
| Created: | 2022-02-03 |
| License: | For personal or educational use |
| Author(s): | Kalen Delaney |
Others related eBooks about SQL Server Internals: In-Memory OLTP
A Primer on SQL, 3rd EditionThis book is an introduction to the basics of SQL. No prior experience with SQL is necessary, but some knowledge of working with computers in general is required. My purpose of writing this was to provide a gentle tutorial on the syntax of SQL, so that the reader is able to recognize the parts of qu...
Essential MySQLThis book written to provide clear and concise explanation of topics for programmers both starting to learn the MySQL programming as well as those diving in more complex topics. Most examples are linked to online playground that allows you to change the code and re-run it....
Graph Databases For BeginnersDownload free course Graph Databases For Beginners, pdf file on 46 pages by Bryce Merkl Sasaki, Joy Chao, Rachel Howard....
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...
Migrating SQL Server Databases to AzureDownload free course Migrating SQL Server Databases to Azure, pdf file on 174 pages by Carl Rabeler....
Microsoft Access TutorialDownloaf Microsoft Access Tutorial in PDF , it'a a free training document intended for beginner's to learn the basics of Microsoft Access database....
SQL Notes for ProfessionalsDownload free course SQL Notes for Professionals, pdf file on 165 pages by Stack Overflow Community....
PostgreSQL tutorial for professionalsDownload free PostgreSQL tutorial course in PDF, training file in 29 chapters and 74 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
SQL Notes for ProfessionalsSQL is a standard language for storing, manipulating and retrieving data in relational databases....
SQL Server Backup and RestoreDownload tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....