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 129 parts, the whole series can be found at http://www.nikoport.com/columnstore/. Almost 2 years ago (22nd of March 2018) in Columnstore Indexes – part 121 (“Columnstore Indexes on Standard Tier of Azure SQL DB”) I have already…
My love for the SQLBits is long (and so far I can be sure it was – how can one not admire the group who besides delivering the best tech show on this planet and delivering the highest quality of…
I will not even try to hide my secret wish to deliver a full-day precon in the city where I have made my studies, in Vienna – and since this year (2019) the fine gentlemen running this event have organised…
Continuation from the Data is Overrated* blog post I wanted to point out something that might shock SOME people. Knowledge is overrated* Wait a second, Niko! Did you just write something that … that is pointing that Knowledge is somehow…