Search Results

Columnstore Indexes – part 94 (“Use Partitioning Wisely”)

Continuation from the previous 93 parts, the whole series can be found at http://www.nikoport.com/columnstore/. This blog post will talk about some of the common problematic practices for the Columnstore Indexes and how to avoid or solve them. It is not…

Clustered Columnstore Indexes – part 15 (“Partitioning Advanced”)

Continuation from the previous 14 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This specific post is a direct continuation of the previous one from the part 14, so the database at the moment should have the FactOnlineSales table already partitioned. Lets see what…

Clustered Columnstore Indexes – part 14 (“Partitioning”)

Continuation from the previous 13 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ Lets play with partitioning this time! Get the Contoso BI Database, plug it in and lets start playing! 🙂 We will be working with the FactOnlineSales table – first we need…

SQL Graph, part I

This blog is a kick-off the series that will be dedicated to the graph databases and engines, being more specifically focused on the SQL Graph, that is the newest extension to the SQL Server engine, as well as the Azure…