Continuation from the previous 94 parts, the whole series can be found at https://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…
Continuation from the previous 101 parts, the whole series can be found at https://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…
Continuation from the previous 100 parts, the whole series can be found at https://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…
Continuation from the previous 99 parts, the whole series can be found at https://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…
Continuation from the previous 98 parts, the whole series can be found at https://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.…