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

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    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: 31444

    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.

  • This was removed by the editor as SPAM

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply