CISL

Columnstore Indexes – part 124 (“Estimate Columnstore Compression”)

Columnstore Indexes – part 124 (“Estimate Columnstore Compression”)

Continuation from the previous 123 parts, the whole series can be found at http://www.nikoport.com/columnstore/. For anyone working with SQL Server since version 2005 (with Service Pack 2 to be precise) there is a very common task when thinking or research…

Columnstore Indexes – part 110 (“The best column for sorting Columnstore Index on”)

Columnstore Indexes – part 110 (“The best column for sorting Columnstore Index on”)

Continuation from the previous 109 parts, the whole series can be found at http://www.nikoport.com/columnstore/. In this blog post I wanted to share my thoughts & my script that I am using for picking the best column for achieving the best…