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 https://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.…

By Niko Neugebauer | November 28, 2015 | Azure SQLDatabase, BI, business intelligence, Columnstore, Columnstore Blog Post, DataWarehouse, oh22, SQL Server | No Comments |
Read more

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 https://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…

By Niko Neugebauer | November 3, 2015 | BI, business intelligence, Columnstore, Columnstore Blog Post, DataWarehouse, Hekaton, InMemory, oh22, SQL Server | 2 Comments |
Read more