Joe Sack

SQL Server Performance Tuning, High Availability and Disaster Recovery Blog

Category: Performance

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


Detecting Selectivity Guesses

I’ve been mulling over a potential Microsoft Connect item regarding selectivity guess warnings, but I’m uncertain if it would have enough demand to drive product


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.