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 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, the feature...
