SqlServerKudos - Filtered Stats to Counter Data Skew Issues

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Filtered Stats to Counter Data Skew Issues

published 943 days, 5 hours, 29 minutes ago posted by

sa 952 days, 18 hours, 5 minutes ago

Filtered Stats to Counter Data Skew Issues

There are a handful of things that can make SQL Server choose a “bad plan”. They usually revolve around variable sized result sets. Some problematic scenarios are parameter sniffing, data skew, local variables, table variables, UDF’s or complex calculations in the where clause. All of these and more are detailed in my favorite and recently [...]

category: News | clicked: 4 | | source: jasonmassie.com | show counter code

tags: Query Optimizer, Query Tuning, SQL Server, statistics, TSQL

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos