Batch Mode

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is a logical continuation of the blog post that I have published in December 2016 – Columnstore Indexes – part 93 (“Batch Mode…

Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)

Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)

Continuation from the previous 97 parts, the whole series can be found at http://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…

Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”)

Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”)

Continuation from the previous 92 parts, the whole series can be found at http://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…

CISL 1.4.0 is released

CISL 1.4.0 is released

Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0! This release is focusing on the addition of the Extended Events, so that a user of CISL can easily set up the…