June 2015
Intermediate to advanced
1800 pages
70h 6m
English
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), ...
Read now
Unlock full access