Can an InMemory table have a foreign key to a disk-based table? I tried it and got Msg 10778. Here is what the error means and the limits to know.
SQL SERVER – Using dm_db_stats_properties With InMemory OLTP Tables
Does sys.dm_db_stats_properties show modified rows for InMemory OLTP tables? I tested it, and memory-optimized tables are now covered. Here is what I found.
SQL SERVER – How to Find the In-Memory OLTP Tables Memory Usage on the Server
At SQLPASS a DBA asked how to see the memory used by each In-Memory OLTP table. The DMV sys.dm_db_xtp_table_memory_stats answers it. Here is the script.
SQL SERVER – Fix Error Msg 10794, Level 16 – The operation ‘CREATE INDEX’ is not supported with memory optimized tables.
A reader tried my ColumnStore on InMemory OLTP example and got Msg 10794: CREATE INDEX is not supported with memory optimized tables. Here is the fix.
SQL SERVER – Creating Clustered ColumnStore with InMemory OLTP Tables – Operational Analytics
SQL Server 2016 lets you add a Clustered ColumnStore index to InMemory OLTP tables for operational analytics. A teaser of my SQLPASS session, with an example.
SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables
While preparing my SQLPASS session on SQL Server 2016, I explored creating clustered ColumnStore with InMemory OLTP tables. Here is what I learned.
SQL SERVER – Fix Error Msg 35336 Working with ColumnStore Indexes
A bank moving from SQL Server 2012 to 2016 wanted to use non-clustered ColumnStore indexes. Here is the error Msg 35336 we hit and how to fix it.