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

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-analytics-using-in-memory-technology.aspx

 

regards

Sunil