SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Learning Columnstore Indexes

By Site Owners,

Columnstore indexes are a feature that was introduced in SQ LServer 2016, but enhanced in SQL Server 2014 and SQL Server 2016. This section tries to include links for various versions.

Here are a list of links that might help you learn more. Note that many of these are links to other sites and we cannot guarantee they still work. We also should note that some of these, especially Books Online, may change over time.

If you find broken links or think we should have more here, please leave a comment in the discussion for this article.

Stairway to Columnstore Indexes - A good general introduction to the feature and learning how it works step by step.

SQL Server 2016

SQL Server 2014

SQL Server 2012

Continue learning more about SQL Server

View the index of features for the various versions.

Total article views: 3209 | Views in the last 30 days: 6
Related Articles

Columnstore Indexs

Columnstore Indexes for Fast DW The SQL Server 11.0 release (2012) introduces a new data warehouse...


SQL Server 2014: Columnstore Index improvements

In SQL Server 2012, a new feature was added called Columnstore Indexes that resulted in huge query p...


SQL Server – Columnstore Index creation error: A columnstore index cannot be created on a SPARSE column

Hi friends, as we know that in SQL Server 2012 a new feature Columnstore index was introduced which ...


Stairway to Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting an...


What is a Non-Clustered Columnstore Index?

First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows fo...