Columnstore Index: Real-Time Operational Analytics using In-Memory Technology

Published Mar 23 2019 02:09 PM 163 Views
Microsoft
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

http://blogs.technet.com/b/dataplatforminsider/archive/2015/12/09/real-time-operational-analyti...

regards

Sunil


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