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…
Its the end of the another great year (2016) and I already have received an incredible news for the next year – in 2017 I will be coming back to the most amazing data platform conference – the SQLBits, to…
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…