After 2 years in making, a couple of days ago Microsoft has announced RTM (Released to Manufacture) of SQL Server 2014 will happen on 1st of April of 2014. Choosing 1st of April as a GA date sounds like a…
SQL Server 2014 RTM on 1st of April 2014
Presenting at Microsoft MVP OpenSessions 2014 Barcelona
I am very honored to be invited to present a session for Spanish Community at the Microsoft MVP OpenSessions 2014 this upcoming Saturday, 22nd of March in Barcelona. My session will be just 45 minutes and it is called “*Hidden*…
Clustered Columnstore Indexes – part 28 (“Update vs Delete + Insert”)
Continuation from the previous 27 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blog post is all about the architectural specifics & performance optimizations for the Clustered Columnstore Indexes. It is known that Inserts are mostly faster than pure Update operations, since we…
Clustered Columnstore Indexes – part 27 (“Data Load with Delta-Stores”)
Continuation from the previous 26 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Let us consider a situation when we are using so-called Trickle Loads into Delta-Stores of a Clustered Columnstore Index. Naturally, this is a not very much desired situation, since the best…
Clustered Columnstore Indexes – part 26 (“Backup & Restore”)
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…