Hekaton

Columnstore Indexes – part 121 (“Columnstore Indexes on Standard Tier of Azure SQL DB”)

Columnstore Indexes – part 121 (“Columnstore Indexes on Standard Tier of Azure SQL DB”)

Continuation from the previous 120 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Yesterday, Kevin Farlee (Program Manager for Columnstore Indexes) announced that Columnstore Indexes have finally found their way into Standard Tier of the Azure SQL Database, I…

Columnstore Indexes – part 119 (“In-Memory Columnstore Location”)

Columnstore Indexes – part 119 (“In-Memory Columnstore Location”)

Continuation from the previous 118 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This is a rather simple blog post that is dedicated to the theme of the In-Memory Columnstore Indexes location. This has been a constant topic of…

Columnstore Indexes – part 96 (“Nonclustered Columnstore Index Online Rebuild”)

Columnstore Indexes – part 96 (“Nonclustered Columnstore Index Online Rebuild”)

Continuation from the previous 95 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is focused on a very important feature in the modern times of the real time operations – the online operations. The first online…

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…