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.Table of contents
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.
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
Logging, Checkpoint, and Recovery
Native Compilation of Tables and Native Modules
SQL Server Support and Manageability
Others related eBooks about SQL Server Internals: In-Memory OLTP
Tutorial PostgreSQL in pdf
This course about PostgeSQL is a pdf document intended to beginners who wants to learn the basics of PostgreSQL SBGD....
MySQL Notes for Professionals
Download free course MySQL Notes for Professionals, pdf file on 198 pages by Stack Overflow Community....
Learn how to administrate PostgreSQL,a free course training material in PDF By Bruce Momjian....
The Definitive Guide to Graph Databases
Download free course The Definitive Guide to Graph Databases, pdf file on 30 pages by Michael Hungers, Ryan Boyd, William Lyon....
PostgreSQL Shell Commands free PDF
Download free course PostgreSQL Shell Commands free PDF, pdf file on 8 pages by tutorialkart.com....
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....
Download SQLite tutorial in PDF format, document created by StackOverFlow intended to beginners....
Graph Databases For Beginners
Download free course Graph Databases For Beginners, pdf file on 46 pages by Bryce Merkl Sasaki, Joy Chao, Rachel Howard....
Microsoft Access 2013 course
Download free Microsoft Office Access 2013 file under 448 pages,step by step to learn Access and build your skills , course tutorial training on pdf by Joyce Cox and Joan Lambert....
MongoDB tutorial for professionals
Download free MongoDB tutorial course in PDF, training file in 23 chapters and 73 pages. Free unaffiliated ebook created from Stack OverFlow contributor....