columnstore index maxdop

Columnstore Indexes

Stairway to Columnstore Indexes Level 4: Catalog Views

In this level, we will first take a look at how to recognize columnstore indexes in some of the generic catalog views. After that we will investigate the new catalog views that have been added just for columnstore indexes.

Learning Columnstore Indexes

References and links to learn more about columnstore indexes.

Stairway to Columnstore Indexes Level 3: Building The Columnstore

The performance increase columnstore indexes grant when reading data from the index is offset by the expensive process required to build the index. In this Stairway level, Hugo Kornelis walks you through the steps SQL Server takes when building (or rebuilding) a columnstore index.

SELECT INTO vs INSERT INTO on Columnstore

This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.

Columnstore efficiencies

Column Store vs Row Store Indexes

How does a column store index compare to a (traditional)row store index with regards to performance

Tips to Optimize Your SQL Statements - Part 2

Read more tips to optimize SQL statements, specifically on a Data warehouse.

Stairway to Columnstore Indexes Level 2: Columnstore Storage

To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.