This chapter focuses on the programmability aspects of the In-Memory OLTP Engine in SQL Server. It describes the process of native compilation and provides an overview of the natively-compiled modules and T-SQL features that are supported in In-Memory OLTP. Finally, it discusses several questions related to the design of new systems and migration of existing systems to the In-Memory OLTP architecture.
Native Compilation
As you already know, memory-optimized tables can be accessed from regular T-SQL code using the Query Interop Engine. This approach is very flexible. As ...