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…
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…
Continuation from the previous 49 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blogpost is focused on the reading part of the IO subsystem of the Columnstore Indexes. I will try to explain the improvements in the reading process as well as some…
Continuation from the previous 48 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Note: Updated on 05th of March 2015 with information on SQL Server 2012. Having blogged a couple of times on the matters of Segment Elimination (“Data Loading for Better Segment Elimination”,…
Continuation from the previous 47 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is dedicated to one of the most complex problems in Columnstore Indexes – the Internal Pressure within the Columnstore Dictionaries, that makes Row Groups being cut off with number…