Press "Enter" to skip to content

Persist Sample Percent Doesn’t

John Sterrett takes us through a bug in SQL Server:

When a bug jumps out and surprises me I like to share it so others do not run into the same unexpected result. I don’t think there is any reason for a bug to bite multiple people in the butt. Therefore, I want to show you why persist sample percent IS NOT PERSISTED!

Read on for the repro and upvote the Feedback item.