Getting Started with Columnstore Index in SQL Server 2014

Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Though it had several limitations, now SQL Server 2014 enhances the columnstore index and overcomes several of those earlier limitations. In this article series I am going to talk about how you can get started with using this enhanced columnstore index feature in SQL Server 2014 and do some performance tests to understand the benefits.

If you are new to columnstore index, you can refer my earlier articles on the topic to understand it better.

• Understanding New Columnstore Index of SQL Server 2012
• Getting Started with the New Columnstore Index of SQL Server 2012
• New Enhanced Columnstore Index in SQL Server 2014

For more information click here for part 1 and click here for part 2.