Continuation from the previous 61 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have spoken a lot of times on the aspect of the Columnstore Indexes maintenance during my presentations, and I have even written 2 blogposts Columnstore…
I guess in the age of rapid development and releases the fact of General Availability of the Power BI v 2.0 on the last friday, 24th of July 2015 was something that anyone somehow connected to the world of Business…
Continuation from the previous 60 parts, the whole series can be found at https://www.nikoport.com/columnstore/. A lot of financial calculations in the SQL world involves a number of analytical & statistical functions, such as CUME_DIST, LEAD, FIRST_VALUE, PERCENTILE_CONT, LAG, PERCENTILE_DISC, LAST_VALUE,…
Continuation from the previous 59 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This blog post is dedicated to some of the major improvements in SQL Server 2016, related to the Batch Execution Mode. By all means this list…
Continuation from the previous 58 parts, the whole series can be found at https://www.nikoport.com/columnstore/. SQL Server 2016 brings a number of significant improvements in the relation of Columnstore Indexes performance and improvements in String Predicate Pushdown were already described in…