There is a long time topic that has been quite an important item for the data platforms dealing with a significant amount of data – the approximate calculations. Anyone who is not familiar with this topic, can visit the Wikipedia…
Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)
Continuation from the previous 116 parts, the whole series can be found at https://www.nikoport.com/columnstore/ An important issue I have faced already a couple of times in production servers was the usage of the Nonclustered Columnstore Indexes vs the usage of…
CISL 1.5.0 is released
I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released. The biggest news is the initial support for the Azure SQL DataWarehouse, with the 5 scripts (Alignment, Dictionaries, Fragmentation, Row Groups…