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

• Hugo Kornelis

  SSC Guru

  Points: 64790

  More actions

  May 23, 2017 at 8:31 am

  #325925

  Comments posted to this topic are about the item Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016

  ---

  Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
  Visit my SQL Server blog: https://sqlserverfast.com/blog/
  SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/
  

• RonKyle

  SSC-Dedicated

  Points: 31567

  More actions

  June 7, 2017 at 7:16 am

  #1945805

  Thanks for this final section.  I'm upgrading a data warehouse from 2005 to 2016.  Based on what I'd read about columnstore indexes up to this point, it didn't seem possible to get much use out of them.  This article has changed my mind.  To comment on one of your points: one of the big improvements made possible by the changes in SSIS is that the ETL job runs hourly for most of the day.  We are also making the shift from seeing the data warehouse as a strategic reporting to being a partner with the operational reporting as well.  The main source data is a PostgreSQL database, though, so combining the two is not in the cards.