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…
Just one month later after the 1.4.0 release of CISL, I am here again blogging about the new release 1.4.1 which besides bug-fixes and small improvements introduces support for Columnstore Indexes on any edition of SQL Server starting with SQL…
Continuation from the previous 91 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Since the very first version of the Columnstore Indexes in 2012, there has been no support for LOB (large objects binaries). The reason behind not focusing…