In this chapter, we covered how the In-Memory OLTP engine has evolved from the first version released with SQL Server 2014 to the latest version in SQL Server 2017.
Many of the restrictions around data types, constraints, large binary objects, and collations, along with the ability to alter objects without having to drop and recreate them, signal the need for huge improvements for developers. We have also learned that there are still limitations and areas where the use of In-Memory OLTP is not the best choice, or must at least be carefully considered before being chosen.
A vastly more efficient processing engine allows us to consider scenarios where current implementations may benefit from the reduced overhead of the In-Memory OLTP engine. The ability to seamlessly interact between memory-optimized and disk-based objects makes for a very compelling programming experience...
