Columnstore Index: Real-Time Operational Analytics using In-Memory Technology
Published Mar 23 2019 02:09 PM 328 Views
First published on MSDN on Dec 09, 2015

Starting with SQL Server 2016, you can implement real-time operational analytics by combining the OLTP workload with columnstore index. SQL Server offers three possible configurations (a) disk-based tables with nonclustered columnstore index (b) memory-optimized tables with columnstore index (c) clustered columnstore index with one or more btree indexes. I will blog in detail about these in coming weeks but the following blog that I just posted is a good overview. Look forward to your feedback/questions



Version history
Last update:
‎Mar 23 2019 02:09 PM
Updated by: