I am so happy that I can finally announce the very first Columnstore & Memory-Optimised Tables Workshop in the USA: on the 31st of October 2016 the Columnstore & Memory-Optimised Workshop will take place in Redmond, Washington! This workshop will…
This is the very first blog post in a new series on the Batch Mode, welcome & enjoy! I will be going into every detail of Batch Mode that I know off in the upcoming blog posts (yes, there will…
Continuation from the previous 25 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This time I decided to take a look at how having Columnstore Indexes in a database is affecting database backup & restore procedures. I decided to take a simple backup from…
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…