Hi,

the link you provided is very useful to know about the DOs and DONTs, and don't mistake me there is one more mistake to be corrected in your article, you have given as "only non-clustered index" available, but clustered index to available with ColumnStore Index

http://msdn.microsoft.com/en-IN/library/gg492088.aspx

Is available in Enterprise, Developer, and Evaluation editions.

Is updateable.

Is the primary storage method for the entire table.

Has no key columns. All columns are included columns.

Is the only index on the table. It cannot be combined with any other indexes.

Can be configured to use columnstore or columnstore archival compression.

Does not physically store columns in a sorted order. Instead, it stores data to improve compression and performance.

Can index a subset of columns in the clustered index or heap. For example, it can index the frequently used columns.

Requires extra storage to store a copy of the columns in the index.

Is updated by rebuilding the index or switching partitions in and out. It is not updateable by using the DML operations such as insert, update, and delete.

Can be combined with other indexes on the table.

Can be configured to use columnstore or columnstore archival compression.

Does not physically store columns in a sorted order. Instead, it stores data to improve compression and performance. Pre-sorting the data before creating the columnstore index is not required, but can improve columnstore compression.