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.…
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…
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…
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…