Interpreted T-SQL Support for In-Memory OLTP

With just a handful of exceptions, you can access memory-optimized tables just like disk-based tables using interpreted T-SQL queries or DML operations (SELECT, INSERT, UPDATE, or DELETE), ad hoc batches, and SQL modules such as stored procedures, table-value functions, triggers, and views. Interpreted T-SQL refers to any T-SQL batches or stored procedures other than a natively compiled stored procedure.

Interpreted T-SQL access to memory-optimized tables is referred to as interop access. Interpreted T-SQL access is recommended for ad hoc queries and administrative tasks, reporting queries which typically use constructs not available in natively compiled stored procedures (such as windowing functions), ...

Get Microsoft SQL Server 2014 Unleashed 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.