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

Others sql Tutorials

MySQL tutorial for professionals

Performance Tuning with SQL Server Dynamic Management Views

SQL in 21 days

PostgreSQL Notes for Professionals

MySQL Notes for Professionals

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

Oracle Database Notes for Professionals

This book is the definitive guide to undocumented and partially-documented features of the Oracle Database server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to Oracle databases. It is packed with of experience over deca...

MySQL – Create Database free PDF

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

PostgreSQL tutorial for professionals

Download free PostgreSQL tutorial course in PDF, training file in 29 chapters and 74 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

SQL Interview Questions free PDF

Download free course SQL Interview Questions free PDF, pdf file on 17 pages by tutorialkart.com....

Oracle Advanced PL/SQL Developer Professional Guide

PL/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 ....

Oracle database tutorials for professionals

Download free Oracle tutorial course in PDF, training file in 45 chapters and 118 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

How to Install SQL Server 2008

With 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 Access course

This PDF tutorial shows how to construct a complex application in Microsoft Access ,free training lesson under 154 pages by Soren Lauesen designated to the intermediate level-user....

SQL Server Concurrency

Download free course SQL Server Concurrency, pdf file on 181 pages by Kalen Delaney....

Guide Microsoft Access 2010

This document is a quick tutorial guide about Microsoft Access 2010 to learn how to store informations in an easily retrievable form....