Columnstore Indexes – part 61 (“Window aggregate functions”)

Columnstore Indexes – part 61 (“Window aggregate functions”)

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,…

Columnstore Indexes – part 60 (“3 More Batch Mode Improvements in SQL Server 2016”)

Columnstore Indexes – part 60 (“3 More Batch Mode Improvements in SQL Server 2016”)

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…