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…
Tuga IT 2017 Tickets are on sale
Columnstore Indexes – part 101 (“Estimated? Similar! Similar How?”)
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…
Columnstore Indexes – part 100 (“Identity”)
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…
Columnstore Indexes – part 99 (“Merge”)
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.…
Columnstore Indexes – part 98 (“Null Expressions & String Aggregates”)
Continuation from the previous 97 parts, the whole series can be found at https://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…