Case Study: Comparison Between Traditional Indexing and Columnstore Indexes in SQL Server 2012
Anas A. Amro, Mohammed Abutaha
Progress in Machines and Systems, Vol. 2, No. 1, 2013.
DOI: 
Link: http://www.dline.info/pms/fulltext/v2n1/1.pdf
Abstract:
The SQL Server 2012 has a new feature to improve performance of data warehouse queries called Columnstore index, stores data by columns instead of by rows. This paper discusses the new type of index in some details, what is a column store, how and why improves the speed up and performance of the same queries that processing in SQL Server when it used this index, and talk a limitation and advantages of this new indexes, then the summarization and resulting is illustrated by example queries. And it will clarify many things on this subject.