It has been quite some time, that the term Modern Data Warehouse has appeared on the horizon of so many data professionals and publications around the world. Some people describe this term as a conjunction of many different types of…
SQLSaturday #267 Lisbon, Portugal 2014
WE did it again, SQLSaturday Lisbon, Portugal 2014 was a major success. With around 250 attendees (final numbers are coming next week, since we are allowing ourselves to relax after all craziness) spread over 7 tracks this was the biggest…
Clustered Columnstore Indexes – part 29 (“Data Loading for Better Segment Elimination”)
Continuation from the previous 28 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ One of the key performance factors for Columnstore Indexes is Segment Elimination. I have been presenting on this matter for quite a while, but never actually blogged about it. Every Columnstore…