ETL Patterns with Clustered Columnstore Indexes

Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes.

Using different Hardware might lead you to different conclusions,and the size of the workload is always the paramount of your performance.

Loading data first and then creating a Clustered Columnstore or creating Clustered Columnstore and than loading - join me to find the answers!
Presented by Niko Neugebauer at SQLBits XII
  • Downloads
    Slide deck available Slide deck 560 KB
    Video available MP4 Video HD 524 MB
  • SpeakerBIO
    Niko Neugebauer works at OH22 as a BI Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about Data Platform and Community.  Founder of the Portuguese SQL Server User Group, the organiser of the first SQLSaturday outside of North America – #78 Portugal, Niko presented at a lot of events such as PASS Summit, SQLRally, SQLBits, SQLSaturdays around the world. He loves sharing and is an author of blog series with 80+ posts on the Columnstore Indexes.
  • Video