ColumnStore Index

Stairway to Columnstore Indexes

Stairway to Columnstore Indexes Level 3: Building The Columnstore

  • Stairway Step

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.

2022-08-10 (first published: )

9,343 reads

Stairway to Columnstore Indexes

Stairway to Columnstore Indexes Level 2: Columnstore Storage

  • Stairway Step

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.

5 (2)

2022-06-29 (first published: )

12,174 reads


Daily Coping 7 Dec 2022


Today’s coping tip is to stop for a minute when you walk outside and...

Encryption and Data Protection Regulation


One of the reasons you may be considering encryption is due to the relevant...

Types of data consulting engagements and what you can expect from them


There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Read the latest Blogs


Either/ Or Query

By dec_obrien

Hi, I have a table containing some columns and some simple data. I want...

Any good resource to learn Data Factory ?

By kalpitaru

I just joined a company and I'm new to Azure. It's a powerful tool...

query, compare and match against values in date and time columns

By brian.cook

So, I need to calculate the distance between the UNIT for example LPKC1 to LPKC2,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers