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…
I am glad to announce thatTuga IT 2017 Tickets are finally on sale! Wait a second, you might think – on sale? How on earth and why in this galaxy (TM) are we asking for the money? What are we…
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.…