Chapter 12. In-Memory OLTP Improvements in SQL Server 2016

When In-Memory OLTP was introduced in SQL Server 2014, many developers were initially excited. The hope of a new, ultra-high-performance data processing engine, coupled with a leading relational database engine, offered a potentially massive improvement for many SQL Server developers. However, this excitement quickly turned into mild disappointment at the number of restrictions assigned to In-Memory OLTP. Many of these restrictions prevented wide adoption of the technology and forced it into a niche set of very tight implementation scenarios. Some of these restrictions, such as lacking support for large data object types (LOBs) or the missing support for ALTER commands, dampened many people's ...

Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.