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
