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: | 83 |
| Created: | 2022-02-03 |
| License: | For personal or educational use |
| Author(s): | Kalen Delaney |
Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233
Others sql Tutorials
Oracle Advanced PL/SQL Developer Professional Guide
Others related eBooks about SQL Server Internals: In-Memory OLTP
SQL Server Backup and RestoreDownload free course SQL Server Backup and Restore, pdf file on 381 pages by Shawn McGehee....
Learning access-vba PDF courseDownload free Access vba tutorial course in PDF, training file in 5 chapters and 207 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
Introduction to SQL Server 2008This pdf course is designed to teach you Microsoft SQL Server. This is a practical training to learn the basics of the Microsoft Database Management System, in its 2008 version....
Download PLSQL tutorial in pdfDownload free PLSQL tutorial course in PDF, training file in 14 chapters and 47 pages. Free unaffiliated ebook created from Stack OverFlow contributor....
MongoDB Tutorial free PDFDownload free course MongoDB Tutorial free PDF, pdf file on 5 pages by tutorialkart.com....
MySQL Notes for ProfessionalsDownload free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community....
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 BeginnersWhether you're a business executive or a seasoned developer, something has led you on the ..., download free Graph Databases tutorial in PDF (46 pages) created by Bryce Merkl Sasaki ....
Learning MySQLDownload free course intituled Learning MySQL, a PDF document created by StackOverflow Documentation, a 300-page tutorial on the basics of this language to learn and manipulate databases created with MySQL....
PostgreSQL Shell Commands free PDFDownload free course PostgreSQL Shell Commands free PDF, pdf file on 8 pages by tutorialkart.com....