Assume that you have a database that has Read Committed Snapshot Isolation (RCSI) enabled by setting option READ_COMMITTED_SNAPSHOT
on in Microsoft SQL Server 2014. When you access both a memory-optimized table and a memory-optimized table variable in the same statement outside the context of a user transaction, the operation may fail. Additionally, you may receive the following error:
Msg 41359. A query that accesses memory optimized tables using the READ COMMITTED isolation level, cannot access disk based tables when the database option READ_COMMITTED_SNAPSHOT is set to ON. Provide a supported isolation level for the memory optimized table using a table hint, such as WITH (SNAPSHOT).