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 the potential of significant improvement for many SQL Server developers. However, this excitement quickly turned into mild disappointment due to the number of restrictions assigned to In-Memory OLTP. Many of these restrictions prevented a widespread adoption of the technology and forced it into a niche set of very tight implementation scenarios. Some of these restrictions, such as minimal support for large data object types (LOBs) and missing support for ALTER commands, dampened ...
In-Memory OLTP Improvements in SQL Server 2017
Get SQL Server 2017 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.
