Joe Sack

SQL Server Performance Tuning, High Availability and Disaster Recovery Blog

Month: February 2013

Redundant Query Plan Branches

Consider the following “basic_member” view definition from the Credit database: A simple SELECT from this view returns 8,498 rows and has the following plan shape


Columnstore Segment Population Skew

My last post about nonclustered Columnstore indexes was written back on February 25th, 2012 (Exploring Columnstore Index Metadata, Segment Distribution and Elimination Behaviors).  Amazed by


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.