Columnstore Indexes – part 73 (“Big Delta-Stores with Nonclustered Columnstore”)

Columnstore Indexes – part 73 (“Big Delta-Stores with Nonclustered Columnstore”)

Continuation from the previous 72 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Since the very first version of SQL Server the maximum size for the Delta-Stores as well as the compressed Row Groups was limited to 1048567 Rows.…

Columnstore Indexes – part 72 (“InMemory Operational Analytics”)

Columnstore Indexes – part 72 (“InMemory Operational Analytics”)

Continuation from the previous 71 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have previously written on the Rowstore Operational Analytics, and now it is the time to dive into the InMemory Operational Analytics in SQL Server 2016…