Querying and data manipulation
Now that we have a memory-optimized table, the next logical step is to start querying the table and manipulating the data stored inside it.
We have two methods of interacting with these memory-optimized objects. Firstly, we can issue standard T-SQL queries and allow the SQL Server Query Optimizer to deal with accessing this new type of table. The second method is to use Natively Compiled Stored Procedures.
Figure 11.4: Overview of the SQL Server engine illustrating Query Interop between In-Memory OLTP and "normal" OLTP
In Figure 11.4, we can see a simplified diagram of a query that is either querying "normal" tables ...
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
