If my table has 1 Clustered Index (PK), and a dozen of non-clustered row-store indexes.
I drop constraint... (existing PK/Clustered Index), Create Clustered Columnstore index on the table.
After this should I drop all my existing rowstore non-clustered indexes or should I still use them and they in fact are expected to work ? Or should I replace each of them with Non-Clustered Columnstore indexes, same columns as rowstore non-clustered indexes?..
Voldemar likes to play CHESS (and IS good at it!)