Transact-SQL Support for In-Memory OLTP
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
The following Transact-SQL statements are modified to support In-Memory OLTP:
ALTER DATABASE File and Filegroup Options (Transact-SQL) (added MEMORY_OPTIMIZED_DATA)
CREATE DATABASE (SQL Server Transact-SQL) (added MEMORY_OPTIMIZED_DATA)
AUTO_UPDATE_STATISTICS is always OFF for memory-optimized tables. For more information, see sp_autostats (Transact-SQL).
Statistics on memory-optimized tables are always updated when executing sp_updatestats (Transact-SQL). Therefore, do not execute sp_updatestats more than necessary.
The modification_counter column in sys.dm_db_stats_properties (Transact-SQL) is not updated for memory-optimized tables.
SET STATISTICS XML (Transact-SQL) ON is not supported for natively compiled stored procedures.
For information on unsupported features, see Transact-SQL Constructs Not Supported by In-Memory OLTP.
For information about supported constructs in and on natively compiled stored procedures, see Supported Features for Natively Compiled Stored Procedures and Supported Constructs on Natively Compiled Stored Procedures.