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: | 96 |
| 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
Guide to NoSQL with Azure Cosmos DB: Create Scalable and Globally Distributed Web Applications
Others related eBooks about SQL Server Internals: In-Memory OLTP
Introduction to Access 2010Start to learn Microsoft Access 2010 with this free PDF tutorial and more about new useful features insides including designing databases and queries,training document for download under 24 ....
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...
SQL Notes for ProfessionalsSQL is a standard language for storing, manipulating and retrieving data in relational databases....
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....
Protecting SQL Server DataDownload free course Protecting SQL Server Data, pdf file on 232 pages by John Magnabosco....
RavenDB in ActionThe data you encounter in the real world is usually easier to think of as objects or docum..., download free RavenDB tutorial in PDF (221 pages) created by Itamar Syn-Hershko ....
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....
Oracle Advanced PL/SQL Developer Professional GuidePL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural ..., download free PL/SQL tutorial in PDF (440 pages) created by Saurabh K. Gupta ....
Getting started with Oracle 8This pdf tutorial is about fundamental of relational database with Oracle , a free training document for Beginners....
Graph DatabasesDownload free course Graph Databases, pdf file on 238 pages by Ian Robinson, Jim Webber, Emil Eifrem....