SQL Server Internals: In-Memory OLTP



Download free course SQL Server Internals: In-Memory OLTP, pdf file on 201 pages by Kalen Delaney.
The SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) is designed to exploit terabytes of available memory and high numbers of processing cores. It allows us to work with memory-optimized tables and indexes, and natively compiled stored procedures, in addition to the disk-based tables and indexes, and T-SQL stored procedures, that SQL Server has always provided.

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 : PDF
Downloads: 63
Created: 2022-02-03
License: For personal or educational use
Author(s): Kalen Delaney
SQL Server Internals: In-Memory OLTP

Others sql Tutorials

PostgreSQL tutorial for professionals

PostgreSQL Shell Commands free PDF

PostgreSQL Shell Commands free PDF

SQL Server Backup and Restore

Introduction to SQL

Others related eBooks about SQL Server Internals: In-Memory OLTP

Graph Databases For Beginners

Download free course Graph Databases For Beginners, pdf file on 46 pages by Bryce Merkl Sasaki, Joy Chao, Rachel Howard....

How To Manage a Redis Database

This book aims to provide an approachable introduction to Redis concepts by outlining many..., download free Redis Database tutorial in PDF (95 pages) created by Mark Drake ....

Learning MySQL

Download 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....

Complete Guide to PostgreSQL

Download free PDF tutorial about PostgreSQL , a complete training material course intended for advanced level users .Document under 2810 pages by The PostgreSQL Global Development Group....

Microsoft SQL Server Notes for Professionals

Download free course Microsoft SQL Server Notes for Professionals, pdf file on 285 pages by Stack Overflow Community....

SQL Notes for Professionals

Download free course SQL Notes for Professionals, pdf file on 165 pages by Stack Overflow Community....

MySQL – Create Database free PDF

Download free course MySQL – Create Database free PDF, pdf file on 3 pages by tutorialkart.com....

Essential SQL

This book written to provide clear and concise explanation of topics for programmers both starting to learn the Structured Query Language (SQL) 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....

SQL Server Backup and Restore

Download tutorial about SQL Server Backup and Restore, it's a free PDF version in 381 pages proposed by Red Gate....

RavenDB in Action

The 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 ....