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…
Speaking at SQLSaturday Vienna
I am glad & honored to be selected as a speaker for the very first edition of SQLSaturday in Vienna, Austria. Organized by the Austrian PASS Chapter leaders Markus Ehrenmüller & Milos Radivojevic, I am greatly excited about this one…