SQLServerCentral Article

Learning In-Memory OLTP


In-Memory OLTP tables and Natively Compiled Stored Procedures were introduced in SQL Server 2014 and have been enhanced in SQL Server 2016 to handle bigger workloads with fewer limitations.

Here are a list of links that might help you learn more. Note that many of these are links to other sites and we cannot guarantee they still work. We also should note that some of these, especially Books Online, may change over time.

If you find broken links or think we should have more here, please leave a comment in the discussion for this article.

SQL Server Internals - In-Memory OLTP - A book from Redgate and SQLServerCentral.

SQL Server 2016

SQL Server 2014

“Have you started using In-Memory OLTP tables yet? If so, you’ll need a safe and reliable way of migrating any changes from one database to the next. The good news is Redgate SQL Compare, the industry standard for comparing and deploying SQL Server databases, supports In-Memory OLTP tables. Data Platform MVP Grant Fritchey Jones explores exactly how this works in Using SQL Compare with In-Memory OLTP Tables.”

Continue learning more about SQL Server

View the index of features for the various versions.