Columnstore Indexes – part 81 (“Adding Columnstore Index to InMemory Tables”)

Columnstore Indexes – part 81 (“Adding Columnstore Index to InMemory Tables”)

Continuation from the previous 80 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Microsoft is doing an amazing job with the every single point release towards SQL Server 2016 RTM. For almost a year, every single month they have…

Columnstore Indexes – part 80 (“Local Aggregation”)

Columnstore Indexes – part 80 (“Local Aggregation”)

Continuation from the previous 79 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Given the number under-the-hood performance & manageability improvements that recent RC versions of SQL Server 2016 have had, I have decided to revisit them and update…

Columnstore Indexes – part 79 (“Loading Data into Non-Updatable Nonclustered Columnstore”)

Columnstore Indexes – part 79 (“Loading Data into Non-Updatable Nonclustered Columnstore”)

Continuation from the previous 78 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Update: In SQL Server 2016 the Nonclustered Columnstore Indexes are UPDATABLE, and you can do any updates without any troubles, for more please read Columnstore Indexes…