Hi Friends,

By this time, many of you already know about columnstore indexes, a column store architecture that groups and stores data for each column on separate pages and then joins all the columns to return data, as required.

Note that you can have only one columnstore index per table and as per Microsoft guidelines, you may want to put many columns in that one index. I am a little scared of putting ‘many’ columns in that one index :) – thus keeping an eye on the size of your columnstore index is critical. Here is a simple example to show how you can determine the size of a columnstore index. The query is widely available on MSDN & TechNet sites.

Here is my customized demo – fill in the blanks and analyze the size of the objects yourself and do post your observations as comments…

Will wait for your observations as comments :)