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…
Continuation from the previous 29 parts, starting from https://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ It has been a long time (almost a year) since Microsoft revealed the public preview version of SQL Server with Clustered Columnstore Indexes available, and ever since there were hundreds of…
This is the third blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL. If you are interested, you may find the very first post at the first blog post of the NodeXL series and the…
This is the second blog post in the series dedicated to the Network Graph Analysis Tool – NodeXL. If you are interested, you may find the very first post at the first blog post of the NodeXL series. In this…