This post is a direct continuation from the previous post on the new Incremental Statistics feature in SQL Server 2014. This time we shall dive into the performance of the Statistics Update statement. To reset the game, I will update…
Continuation from the previous 24 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ I decided to take a simple OLTP table, make it bigger and to tear it apart with Clustered Columnstore & so this blog post is about this experiment. I picked up…
This post is a continuation from the previous post on the new Incremental Statistics feature in SQL Server 2014: In this part lets see how the update of the partitioned table will work. To kick off, I decided to update…
One of my all-time favorite phrases is that “there are 3 kind of lies: lies, damned & statistics”. So let us talk about the statistics in SQL Server :) The presence of statistics is the essential element of the decision…
Disclaimer: THIS IS NOT SUPPORTED BY MICROSOFT, YOU SHOULD BACK UP ANY ORIGINALS BEFORE ALTERING. YOU MIGHT LOOSE SUPPORT IF ADVANCING WITH THIS MODIFICATIONS. Though these modifications are a part of KB 2829948 :) I have to say that I…