Continuation from the previous 98 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is focused on the MERGE statement for the Columnstore Indexes, or as I call it – the worst enemy of the Columnstore Indexes.…
Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)
Continuation from the previous 97 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Continuing with the spirit of the previous blog post on the string data type limitations I decided to add a couple more items that are showing…
SQLPort V2
The new site of SQLPort is finally live. This is not just a redesign of the original site, published in April 2010. This is the start of the second approach that we shall start implementing right from the very next…
Columnstore Indexes – part 97 (“Working with Strings”)
Continuation from the previous 96 parts, the whole series can be found at https://www.nikoport.com/columnstore/. After many years of using & fighting the String data type in Columnstore Indexes, I have finally decided to write a blog post that is dedicated…