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…
I am glad to announce the very first release of the CISL – Columnstore Indexes Scripts Library, with codename “Ortus”. Go on and download the very first release to find out what it is all about. This release consists from…
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,…