Continuation from the previous 64 parts, the whole series can be found at https://www.nikoport.com/columnstore/. This article is dedicated to the improvements to Clustered Columnstore Index in SQL Server 2016. The Clustered Columnstore Index is designed for DataWarehouse & Decision Support…
Continuation from the previous 63 parts, the whole series can be found at https://www.nikoport.com/columnstore/. I have decided to write a rather small blogpost, highlighting the T-SQL improvements already available in SQL Server 2016. The reason behind this blogpost is because…
Continuation from the previous 62 parts, the whole series can be found at https://www.nikoport.com/columnstore/. Data Loading is one of the most important topics for any IT professional, no matter if you are a Data Platform specialist working with huge ETL…
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…
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,…