Columnstore Blog Post

Columnstore Indexes – part 55 (“New Architecture Elements in SQL Server 2016”)

Columnstore Indexes – part 55 (“New Architecture Elements in SQL Server 2016”)

Continuation from the previous 54 parts, the whole series can be found at https://www.nikoport.com/columnstore/ The architectural changes in the upcoming SQL Server 2016 are bringing some very important & long-awaited improvements for the complete Columnstore Indexes architecture in Microsoft SQL…

Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016”)

Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016”)

Continuation from the previous 53 parts, the whole series can be found at https://www.nikoport.com/columnstore/ This is a not very deep technical post, which is describing the upcoming news and changes in SQL Server 2016. Since there is no public CTP…

Clustered Columnstore Indexes – part 53 (“What’s new for Columnstore in SQL Server 2014 SP1”)

Clustered Columnstore Indexes – part 53 (“What’s new for Columnstore in SQL Server 2014 SP1”)

Continuation from the previous 52 parts, the whole series can be found at https://www.nikoport.com/columnstore/ This is a very small blog post which will focus on 1 essential change that happened in Service Pack 1 for SQL Server 2014. The only…

Clustered Columnstore Indexes – part 52 (“What’s new for Columnstore XE in SQL Server 2014 SP1”)

Clustered Columnstore Indexes – part 52 (“What’s new for Columnstore XE in SQL Server 2014 SP1”)

Continuation from the previous 51 parts, the whole series can be found at https://www.nikoport.com/columnstore/ Microsoft has launched Service Pack 1 for SQL Server over a week ago (15th of April was the release date I believe), and unfortunately the original…

Clustered Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”)

Clustered Columnstore Indexes – part 51 (“SSIS, DataFlow & Max Buffer Memory”)

Continuation from the previous 50 parts, the whole series can be found at https://www.nikoport.com/columnstore/ This post is dedicated to usage of one of the most important technologies in ETL space – SQL Server Integration Services and its integration with the…