T-SQL Querying

Chapter 10. In-Memory OLTP

Microsoft SQL Server 2014 introduces the In-Memory OLTP feature. In-Memory OLTP can produce great increases in performance, but you need to understand that the increases are not primarily because the data is resident in memory. Rather, the increases come from leveraging the fact that the data is in memory and using different data structures and methods that make database operations much more efficient. This chapter will help you to understand these different structures and methods and how to use them to unlock the performance potential of In-Memory OLTP. I’ll give a brief overview to help you understand the context, and then discuss the ways in which memory-optimized tables need to be handled differently when writing ...