This blog post is a part of the whole Batch Mode series, which can be found at the Nikoport Batch Mode page. With the initial public CTP release of the SQL Server 2019 – the CTP 2.0 we have finally…
Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)
Continuation from the previous 117 parts, the whole series can be found at https://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”)
Continuation from the previous 116 parts, the whole series can be found at https://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”)
Continuation from the previous 108 parts, the whole series can be found at https://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
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…