If you remember yourself being a new kid on the block to the databases and the concept of the transaction and rollback, or if you have ever worked or working with the people who are new to the principles and…
Database Scoped Configurations in 2018
What would be a good candidate for the very first blog post in 2019? The blog post I started writing in 2018 and did not finish. To be more precise I was planning & opened a draft with some notes…
Announcing “Columnstore & Batch Execution Mode” Channel
It is time. I have been thinking about this for about a year and playing with the idea for way too long, with the concrete plans for the January of 2018, than August 2018 … Anyway – here we go…
Columnstore Indexes – part 126 (“Extracting Columnstore Statistics to Cloned Database”)
Continuation from the previous 125 parts, the whole series can be found at https://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…
Resumable Online Index Creation
It is quite strange to write an article about Resumable Online Index Creation 14 months after writing about Resumable Online Index Rebuild operation, because from the physical world logic there should be first the initial creation and then rebuild process,…