InMemory

Columnstore Indexes – part 83 (“Columnstore Replication in SQL Server 2016”)

Columnstore Indexes – part 83 (“Columnstore Replication in SQL Server 2016”)

Continuation from the previous 82 parts, the whole series can be found at https://www.nikoport.com/columnstore/ A lot of things were changed in SQL Server 2012, which was quite a ground-breaking release if you look at it with a lot of attention…

Columnstore Indexes – part 78 (“Temporary Objects”)

Columnstore Indexes – part 78 (“Temporary Objects”)

Continuation from the previous 77 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have decided to spend some time exploring the opportunities that Columnstore Indexes offer in the relation of the temporary objects. Temporary objects represent a very…

Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)

Columnstore Indexes – part 74 (“Row Group Merging & Cleanup, SQL Server 2016 edition”)

Continuation from the previous 73 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Row Group merging & cleanup is a very long waited improvement that came out in SQL Server 2016. Once Microsoft has announced this functionality, everyone who…