Recently I have made some very interesting discoveries about Hekaton (aka In-Memory OLTP) that I felt absolutely necessary to share with the world. I assume that the most people already know about this specifics, but discovering these details has helped…
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…
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…
I am glad to share that the 1.5.0 release of the CISL (Columnstore Indexes Scripts Library) is finally released. The biggest news is the initial support for the Azure SQL DataWarehouse, with the 5 scripts (Alignment, Dictionaries, Fragmentation, Row Groups…
Continuation from the previous 109 parts, the whole series can be found at https://www.nikoport.com/columnstore/. In this blog post I wanted to share my thoughts & my script that I am using for picking the best column for achieving the best…