ColumnStore Index

Stairway to Columnstore Indexes

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

  • Stairway Step

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.

2019-03-26 (first published: )

2,305 reads

Stairway to Columnstore Indexes

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

  • Stairway Step

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.

2019-03-26 (first published: )

6,323 reads

Stairway to Columnstore Indexes

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

  • Stairway Step

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.

2019-03-26 (first published: )

6,543 reads

Blogs

Tell My Story of Public Speaking

By

This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...

The Last Trip of 2022

By

It’s the last trip for me today. I head to the UK for a...

How to cluster SAP ASCS/SCS with SIOS DataKeeper on VMware ESXi Servers

By

This article describes the steps you take to prepare the VMware infrastructure for installing...

Read the latest Blogs

Forums

Get Date Monday Show results for weekend and then else 24 hours

By DMcMorris@welcom.co.uk

Hi,   I have a SQL query below in which i need to be...

A week in Seattle in 8 Slides at the PASS Data community Summit 2022

By Tonie Huizer

Comments posted to this topic are about the item A week in Seattle in...

ASP.NET website force different windows authenticated user

By Raja mssql

Hi All, We are deploying website by using windows authenticated user. It is default...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers