Virtual Pass

Columnstore Indexes – part 105 (“Performance Counters”)

Continuation from the previous 104 parts, the whole series can be found at http://www.nikoport.com/columnstore/. For a very long time I was intending to write some of the unsung & almost hidden improvements of the SQL Server 2016 – the performance…

Resumable Online Index Rebuild

I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog about it. The new version of SQL Server (2017) introduces a very exciting feature for the DBA’s – the Resumable…

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…

Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)

Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/. I have been wanting to write on this topic for quite some time, but with all the exciting themes that I have on my todo list…

Columnstore Indexes – part 102 (“CCI with Secondary Rowstore Indexes on SQL 2014”)

Continuation from the previous 101 parts, the whole series can be found at http://www.nikoport.com/columnstore/. In SQL Server 2014 we have received a possibility to update the Columnstore Index directly with an addition of the Clustered Columnstore Index. This addition had…

Columnstore Indexes – part 101 (“Estimated? Similar! Similar How?”)

Continuation from the previous 100 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blogpost will focus on warning you against considering just 1 aspect when analysing Columnstore Indexes performance, while coming back to the good old theme of…

Columnstore Indexes – part 100 (“Identity”)

Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/. In Data Warehousing one will not be shocked to find a number of tables using IDENTITY property on a column, a lot of times to create…

Columnstore Indexes – part 99 (“Merge”)

Continuation from the previous 98 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post is focused on the MERGE statement for the Columnstore Indexes, or as I call it – the worst enemy of the Columnstore Indexes.…

Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)

Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Continuing with the spirit of the previous blog post on the string data type limitations I decided to add a couple more items that are showing…

Columnstore Indexes – part 97 (“Working with Strings”)

Continuation from the previous 96 parts, the whole series can be found at http://www.nikoport.com/columnstore/. After many years of using & fighting the String data type in Columnstore Indexes, I have finally decided to write a blog post that is dedicated…
Go to Top