Hugo Kornelis

Stairway to Columnstore Indexes

Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016

This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016.

5 (1)

2020-07-22 (first published: )

3,910 reads

Stairway to Columnstore Indexes

Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes

In Level 7, we looked at optimizing rowgroup elimination for a nonclustered columnstore index. For a clustered columnstore index, the same technique can be used but the steps and syntax change a bit. This will be covered later – but first, let’s take a look at another significant difference between nonclustered and clustered columnstore indexes, […]

2019-01-23 (first published: )

6,700 reads

Stairway to Columnstore Indexes

Stairway to Columnstore Indexes Level 5: Adding New Data To Columnstore Indexes

Earlier levels have shown how Columnstore Indexes work effectively with static data. In most tables however, data is hardly ever static. We are constantly inserting new rows, and updating or deleting existing rows. If you think about what this means for a columnstore index, you will realize that this comes with some unique challenges.

2018-12-19 (first published: )

5,563 reads

Stairway to Columnstore Indexes

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

The previous levels of this stairway describe details, features, and limitations of columnstore indexes in SQL Server. But they do not answer what should be the first question for every database professional: should columnstore indexes be used in my databases; on what tables should they be used; and should they be clustered or nonclustered columnstore indexes?

2018-10-03 (first published: )

2,383 reads

Stairway to Columnstore Indexes

Stairway to Columnstore Indexes Level 11: Optimizing Queries For Batch Mode (Part 2)

Hugo Kornelis continues his exploration of the types of queries that can end up running in row mode when accessing columnstore indexes. He demonstrates how careful rewriting can often yield a logically equivalent query that runs in batch mode instead, and therefore gains the best possible performance benefit.

2018-09-05 (first published: )

1,965 reads

Blogs

Power BI Monthly Digest – August 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 14 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Setting default values for Array parameters/variables in Azure Data Factory

By

(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Location Data Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Location Data Privacy

TextBox Property>Action>GotoURL for Multiple Values?

By jbalbo

Hi I am using two stuff commands in my query. One gets the date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers