Bi-kipedia
Microsoft Columnstore Indexes
A "columnstore” index within Microsoft SQL Server 2012 stores each column in a separate set of disk pages, rather than storing multiple rows per page which is the way data is stored traditionally.Benefits of this are: