Transact-SQL Support for In-Memory OLTP

SQL Server 2016 and later
 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

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

Community Additions

ADD
Show: