Welcome to my series on the CosmosDB, you might enjoy them, or you might not. :) This represents my current opinion and view on this platform at this very moment and it might change in the future (given that I…
CosmosDB: NoSQL, NoDBA & NoProblem?
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…
Columnstore Indexes – part 105 (“Performance Counters”)
Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/. For a very long time I was intending to write some of the unsung & almost hidden improvements of the SQL Server 2016 – the performance…
Resumable Online Index Rebuild
I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog about it. The new version of SQL Server (2017) introduces a very exciting feature for the DBA’s – the Resumable…
CISL 1.4.0 is released
Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0! This release is focusing on the addition of the Extended Events, so that a user of CISL can easily set up the…