Batch Mode

Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)

Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)

Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/. As a logical continuation from the blog post Columnstore Indexes – part 91 (“SQL Server 2016 Standard Edition Limitations”), this blogpost will focus on the SQL…

Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)

Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)

Continuation from the previous 116 parts, the whole series can be found at http://www.nikoport.com/columnstore/ An important issue I have faced already a couple of times in production servers was the usage of the Nonclustered Columnstore Indexes vs the usage of…

Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)

Columnstore Indexes – part 109 (“Trivial Plans in SQL Server 2017”)

Continuation from the previous 108 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Do you remember one of the major problems in SQL Server 2014 using Columnstore Indexes ? It was the lack of the support for the Batch…

Precon at PASS Summit 2017 – Columnstore Indexes: Practical Solutions & Techniques

Precon at PASS Summit 2017 – Columnstore Indexes: Practical Solutions & Techniques

It is with an incredible joy and gratitude that I am able to share that I will be delivering a full-day precon (workshop) at PASS Summit 2017: Columnstore Indexes – Practical Solutions & Techniques on 31st of October 2017 in…

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is a logical continuation of the blog post that I have published in December 2016 – Columnstore Indexes – part 93 (“Batch Mode…