This post is to correct a mistake I made in my previous post on Updateable Non Clustered Columnstore index in SQL 2016; in that post I mentioned that Clustered Columnstore index doesn’t allow other indexes to be create on the table. This is true and false.
Let me explain.
If your using SSMS to create the index then you will see the below screen and message
However if you use the T-SQL Command you can still create the index on the table as shown below. In this case I guess it’s just SSMS that’s not updated.
I have raised a connect for this at the below link
https://connect.microsoft.com/SQLServer/Feedback/Details/1552617
How to achieve something similar in SQL 2014
http://www.brentozar.com/archive/2014/03/add-nonclustered-indexes-clustered-columnstore-indexes/
Please Consider Subscribing
