Transact-SQL Support for In-Memory OLTP
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.