May 23, 2017 at 8:31 am
Comments posted to this topic are about the item Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016
June 7, 2017 at 7:16 am
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy