SQL Server 2012 Partitioned Index Default Sampling Algorithm Changes When moving from SQL Server 2008+ to SQL Server 2012, be aware that the sampling algorithm has changed. For example, I created a partitioned clustered Explore
Exploring Columnstore Index Metadata, Segment Distribution and Elimination Behaviors I was interested in exploring various questions about columnstore indexing this morning – and I realized I should probably blog about what I observed. This Explore