SqlServerKudos - Sampling Problem with Filtered Statistics

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

Sampling Problem with Filtered Statistics

published 837 days, 21 hours, 52 minutes ago posted by

sa 847 days, 11 hours, 1 minute ago

Sampling Problem with Filtered Statistics

I was writing a blog post to show how to solve the problem of bad estimations due to uneven data distribution with filtered statistics. After an hour or so of banging my head against the wall, I discovered that I ran into a bug feature. It appears that if the predicate on the filtered stats [...]

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

tags: bugfix, filtered indexes, Query Optimizer, SQL Server, statistics

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos