Continuation from the previous 35 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ At the 12th Edition of SQLBits around 1 week ago I have had a short but interesting conversation about Columnstore Indexes, its sizes and its importance for rebuild processes with Ola…
I love SSIS Server, it was one of the greatest addition to the SQL Server Integration Services in 2012 version without any doubt, even though the RTM bits were not production ready. There is one issue with the SSIS Project…
This blog post is a continuation of the initial announcement almost a month ago about the session selection process that we decided to do for SQLSaturday Portugal Oporto 2014 Edition, that I have initially blogged about at SQLSaturday Porto edition…
There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones. There is a technological event that is called SQLBits. It’s 12th edition last weekend was a different one. For me it was…
Continuation from the previous 34 parts, starting from https://www.nikoport.com/2014/07/20/clustered-columnstore-indexes-part-34-deleted-segments-elimination/ This blog post is about controlling some of the Columnstore Indexes behaviours in less obvious ways – by using Trace Flags & Query Optimiser Rules. I will be looking into updating…