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