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…
Continuation from the previous 95 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is focused on a very important feature in the modern times of the real time operations – the online operations. The first online…
Continuation from the previous 94 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this blog post I am continuing showing some of the solutions for the common problematic places for the Columnstore Indexes. Here I will focus on…
Continuation from the previous 93 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post will talk about some of the common problematic practices for the Columnstore Indexes and how to avoid or solve them. It is not…
Continuation from the previous 92 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Given that currently the Batch Execution Mode is an exclusive feature of the Columnstore Indexes, and that the new developments in the query optimisation area are…