This blog post is a continuation of a small series of posts that I am writing about Azure SQL DW Materialized Views, and you can catch up the initial things in Azure SQL DW Materialized Views (part 1). In this…
A couple of months a very exciting announcement has been made by Microsoft (that went totally ignored by the vast majority of the market) – the implementation of the Materialized Views in Azure SQL DW (Also known as Azure Synapse…
The main idea about Result Set Caching is very simple – you take the already processed results from the complex expensive queries and store it accessible so when the very same query arrives asking for the result again, the server…
Continuation from the previous 127 parts, the whole series can be found at http://www.nikoport.com/columnstore/. First of all and before everything else, I would like to extend my gratitude to Xiaoyu Li (Microsoft PM) for taking her time and exchanging long…
There is a long time topic that has been quite an important item for the data platforms dealing with a significant amount of data – the approximate calculations. Anyone who is not familiar with this topic, can visit the Wikipedia…