A new free ebook by Kalen Delaney on the internals of SQL Server 2016 In-Memory OLTP has been published by Simple Talk (redgate), which introduces and explains how SQL Server 2016 In-Memory OLTP engine (a.k.a. Hekaton) works. This book goes into detail about the in-memory engine and will help you with migrate existing databases and tables over to Hekaton for beyond imaginable performance.
“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.”
Working with Hekaton in-memory data is very accessible using T-SQL and SSMS. However there are some limitations and this book goes into detail about what’s possible and what’s not and how to get around the issues.
Download your the free ebook here.