From the very first SQLSaturday event that I have helped to create (SQLSaturday #78 Portugal), I have always desired to make the process of session selection to be a more community-oriented and open process. I know personally the vast majority…
Achievement unlocked. I am more than delighted to announce that I was selected to speak at the upcoming PASS Summit 2014 in November of 2014 in the beautiful city of Seattle. Every Microsoft Data Platform professional, every Microsoft Employee doing…
I am extremely delighted to announce that I was selected to present a Deep Dive session on Clustered Columnstore Indexes at the very first SQLSaturday Edition in the beautiful city of Oslo, Norway. This event is to be held on…
Continuation from the previous 31 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ The Columnstore Row Group Size Question: What is better for SQL Server performance: to have a big Row Groups (1.045.678 rows) or to have them as small as possible (100.000 rows)…
Continuation from the previous 30 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This blog post is focusing on one of the most important real world issues – Memory Pressure. While testing on your own Computer or on some development server in a controlled…