Joe Sack

SQL Server Performance Tuning, High Availability and Disaster Recovery Blog

Day: February 25, 2012

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

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.

Joe Sack

Day: February 25, 2012

SQL Server 2012 Partitioned Index Default Sampling Algorithm Changes

Exploring Columnstore Index Metadata, Segment Distribution and Elimination Behaviors

Categories

Blog Home

Imagine feeling confident enough to handle whatever your database throws at you.