SQL Server

Columnstore Indexes – part 119 (“In-Memory Columnstore Location”)

Columnstore Indexes – part 119 (“In-Memory Columnstore Location”)

Continuation from the previous 118 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This is a rather simple blog post that is dedicated to the theme of the In-Memory Columnstore Indexes location. This has been a constant topic of…

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…