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
- Books Online - In-Memory OLTP
- SQL Server 2016: In-Memory OLTP Enhancements
- In-Memory OLTP - The faster is now simpler
SQL Server 2014
- Books Online - In-Memory OLTP
- SQL Server Internals: In-Memory OLTP (Kalen Delaney ebook, free PDF download, sign up required)
- Creating Memory-Optimized Tables in SQL Server 2014
- The Ins and Outs of In-Memory OLTP
- Getting Started with SQL Server In-MEmory OLTP (technet)
- How to Create In-Memory Database Tables in SQL Server 2014
- Getting Started with SQL Server 2014 In-Memory OLTP
- Thinking Outside of In-Memory Box: Supporting Uniqueness and Referential Integrity in In-Memory OLTP
“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.