Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

Question

Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?

Hugo Kornelis

SSC Guru

Points: 64790
More actions
May 17, 2017 at 7:06 pm

#336982

Comments posted to this topic are about the item Stairway to Columnstore Indexes Level 12: Clustered or Nonclustered?
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/

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

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

doug.bishop SSC Enthusiast Points: 118 More actions · Answer 1

I've just recently been reading up on columnstore indexes. We are on SQL Server 2016, and given the original publication date of this article, I am really surprised that you don't cover the additional enhancements that Microsoft has made in 2016 regarding the use of columnstore indexes. Most of the limitations you mention are addressed in SQL Server 2016 (and even more-so in 2017).

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 2

Hi Doug,

Thanks for the feedback - much appreciated!
Due to the many changes in SQL Server 2016, we decided to add one extra level where these are described: http://www.sqlservercentral.com/articles/Stairway+Series/157415/

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/