Columnstore Clustered vs Nonclustered, When to Choose What by Niko Neugebauer

The incredible Columnstore Indexes can increase your analytical query processing speed multiple times, they are updatable (Clustered from SQL Server 2014 and Nonclustered from SQL Server 2016 respectively), but they keep on supporting different sets of the functionalities – such as Change Data Capture (Nonclustered Columnstore) or LOBs (Clustered Columnstore), and this brings a great confusion onto the table. This session will light up your path on when to use what functionality to use and when, even though sometimes one of the type of the Columnstore Indexes does not seems to appear as a default choice for your scenario.

You can listen to Columnstore Clustered vs Nonclustered, When to Choose What by Niko Neugebauer online on Radio and Podcast. Open the player on this page to stream the available audio.

Columnstore Clustered vs Nonclustered, When to Choose What by Niko Neugebauer is an episode from GroupBy – Free SQL Server Training by Brent Ozar.

This episode is 01:08:16 long.

This episode was published on Jun 12, 2018.

Yes. Use the heart button on the episode page to add it to your favorite episodes list.

Yes. This page shows related episodes from GroupBy – Free SQL Server Training when more episodes are available from the podcast feed.