I decided to start publishing the literature I am reading and to kick it off, I want to revisit books that I have read in 2013. Unfortunately there were not many of them, but since I strongly believe in the…
Books I read in 2013
Clustered Columnstore Indexes – part 25 (“Faster Smaller Better Stronger”)
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…
Statistics: Incremental (2014) – Part 2
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…
Statistics: Incremental (2014) – Part 1
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…
Fixing SSISDB Performance Troubles (KB 2829948)
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…