Clustered Columnstore Indexes – part 38 (“Memory Structures”)

Continuation from the previous 37 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
In the past I have been writing quite a lot on the...

Clustered Columnstore Indexes – part 37 (“Deleted Bitmap & Delta-Store Sizes”)

Continuation from the previous 36 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Since the very first CTP beta, I have been asking for some...

Linchpin by Seth Godin

I am not sure how many books by Seth Godin I do own, I guess that it is somewhere around...

Batch Mode – part 1 (“The Beginning”)

This is the very first blog post in a new series on the Batch Mode, welcome & enjoy!
I will be going...

Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”)

Continuation from the previous 35 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
At the 12th Edition of SQLBits around 1 week ago I have...

SSIS Project Deployment under different name

I love SSIS Server, it was one of the greatest addition to the SQL Server Integration Services in 2012 version...

SQLSaturday Porto Edition 2014 Selection Process Results & Voting

This blog post is a continuation of the initial announcement almost a month ago about the session selection process that...

SQLBits XII Recap

There are different type of events – good ones, great ones, mediocre ones, bad ones & excellent ones.

There is a technological event...

Clustered Columnstore Indexes – part 35 (“Trace Flags & Query Optimiser Rules”)

Continuation from the previous 34 parts, starting from http://www.nikoport.com/2014/07/20/clustered-columnstore-indexes-part-34-deleted-segments-elimination/
This blog post is about controlling some of the Columnstore Indexes behaviours...

Clustered Columnstore Indexes – part 34 (“Deleted Segments Elimination”)

Continuation from the previous 33 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Segment Elimination for Deleted Row Groups
After some very interesting and inspiring conversations...