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…

Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)

Columnstore Indexes – part 90 (“In-Memory Columnstore Improvements in Service Pack 1 of SQL Server 2016 “)

Continuation from the previous 89 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is focusing on a very important improvement to the limitation of the In-Memory Columnstore Indexes that was existing in SQL Server 2016, but…