Using Open Source Products to Collect Performance Metrics by Tracy Boggiano
Feb 12, 2019 - 56:55
Radio and PodcastLive Radio & PodcastsTechnology
Columnstore Indexes: What are waiting for? by Niko Neugebauer
Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there are whole execution plans behind those Index Scans ? Did you ever ask yourself, what are those strange and weird HT...
About This Episode
Columnstore Indexes: What are waiting for? by Niko Neugebauer is an episode from GroupBy – Free SQL Server Training by Brent Ozar. Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there are...
Podcast
This episode belongs to GroupBy – Free SQL Server Training.
Listen Online
Use the player on this page to stream the episode online.
Episode Details
Published Feb 5, 2019, 01:18:35 long, audio available.
Related Episodes
Continue listening to more episodes from GroupBy – Free SQL Server Training.
The Problems With Optional Operators by Erik Darling and Joe Obbish
Jan 29, 2019 - 01:02:24
How to get your dream job: Resume & job hunting tips by Andy Mallon
Jan 22, 2019 - 52:59
New Engine Features in SQL Server 2019 by Aaron Bertrand
Jan 8, 2019 - 54:09
An Introduction to Partitioning by DBAfromthecold
Oct 23, 2018 - 57:05
Make Your Own SQL Server Queries Go Faster by John Sterrett
Oct 16, 2018 - 01:03:28
T-SQL Tools: Simplicity for Synchronizing Changes by Martin Perez
Oct 9, 2018 - 01:04:12
Questions About This Episode
What is Columnstore Indexes: What are waiting for? by Niko Neugebauer about?
Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there are whole execution plans behind those Index Scans ? Did you ever ask yourself, what are those strange and weird HT_* waits stand for ? Why do we wait for seconds/minutes for something like HTBUILD while it seems that nothing happens ? Why do we have a ROWGROUP_VERSION wait on one server, while the other allows queries to run faster ? This session focuses on answering those question - to help you understand the reasons and the conditions behind every single available wait for the Columnstore Indexes and the Batch Execution Mode.
Where can I listen to Columnstore Indexes: What are waiting for? by Niko Neugebauer?
You can listen to Columnstore Indexes: What are waiting for? by Niko Neugebauer online on Radio and Podcast. Open the player on this page to stream the available audio.
Which podcast is Columnstore Indexes: What are waiting for? by Niko Neugebauer from?
Columnstore Indexes: What are waiting for? by Niko Neugebauer is an episode from GroupBy – Free SQL Server Training by Brent Ozar.
How long is this episode?
This episode is 01:18:35 long.
When was this episode published?
This episode was published on Feb 5, 2019.
Can I save Columnstore Indexes: What are waiting for? by Niko Neugebauer for later?
Yes. Use the heart button on the episode page to add it to your favorite episodes list.
Are there related episodes from GroupBy – Free SQL Server Training?
Yes. This page shows related episodes from GroupBy – Free SQL Server Training when more episodes are available from the podcast feed.
Quick Answers About This Episode
Where can I listen to Columnstore Indexes: What are waiting for? by Niko Neugebauer?
You can listen to Columnstore Indexes: What are waiting for? by Niko Neugebauer on this page when the episode audio is available from the podcast feed.
Which podcast is this episode from?
Columnstore Indexes: What are waiting for? by Niko Neugebauer is from GroupBy – Free SQL Server Training by Brent Ozar.
What are the episode details?
Published Feb 5, 2019 and 01:18:35 long