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…

Columnstore & Memory-Optimised Workshop in Redmond (10.31-11.02 2016)

Columnstore & Memory-Optimised Workshop in Redmond (10.31-11.02 2016)

I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on the 31st of October 2016 the Columnstore & Memory-Optimised Workshop will take place in Redmond, Washington! This workshop will…