Columnstore Blog Post

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…

Columnstore Indexes – part 92 (“Lobs”)

Columnstore Indexes – part 92 (“Lobs”)

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

Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”)

Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”)

Continuation from the previous 90 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Given the improvements and the availability of the of the programability surface for every edition (with some insignificant & logical limitations) that I have blogged about…