I am extremely happy to share that I shall be delivering a workshop at the amazing SQLSaturday Cambridge on 10th of September 2015 (Thursday). As you would expect, this whole day experience will focus on my favourite functionality in the…
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”,…