Chapter 12. In-Memory OLTP Improvements in SQL Server 2017
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 many people's enthusiasm for the technology.
As with previous features inside SQL Server, In-Memory OLTP has followed a similar pattern. SQL Server 2014 saw the introduction of the In-Memory OLTP Engine. With SQL Server 2016 and again in 2017...