DBA

Columnstore Indexes – part 126 (“Extracting Columnstore Statistics to Cloned Database”)

Columnstore Indexes – part 126 (“Extracting Columnstore Statistics to Cloned Database”)

Continuation from the previous 125 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have a huge love for the DBCC CLONEDATABASE command – it has been made available (backported) to every SQL Server version starting with SQL Server…

Columnstore Indexes – part 106 (“Memory Requirements for Rebuild & Reorganize”)

Columnstore Indexes – part 106 (“Memory Requirements for Rebuild & Reorganize”)

Continuation from the previous 105 parts, the whole series can be found at http://www.nikoport.com/columnstore/. One of the most important and recurring topics for any type of indices is their Building/Rebuilding/Reorganzing processes – after all we do load more data into…