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,…
There are a number of high quality events in Europe that are being run by the local volunteers or user groups. SQLServerDays in Belgium is one of those high-end payed events organised by the local user group that you will…
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…
Continuation from the previous 57 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have previously blogged on the predicate pushdown matter in the post Columnstore Indexes – part 49 (“Data Types & Predicate Pushdown”), and from the published…