Transact-SQL Support for In-Memory OLTP

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

The following Transact-SQL statements include syntax options to support In-Memory OLTP:

AUTO_UPDATE_STATISTICS can be ON for memory-optimized tables, starting with SQL Server 2016. For more information, see sp_autostats (Transact-SQL).

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 T-SQL Modules and Supported DDL for Natively Compiled T-SQL modules.

See Also

In-Memory OLTP (In-Memory Optimization)
Migration Issues for Natively Compiled Stored Procedures
Unsupported SQL Server Features for In-Memory OLTP
Natively Compiled Stored Procedures