Setting the Sample Rate for Automatic Statistics updates

,

I talked a few posts ago about Automatic Sample Sizes for Statistics Updates. From SQL 2016 CU4 we've been able to override that. You can manually update a statistics object specifying a given sample rate, and specify that that sample rate is what will be used for any subsequent automatic updates on the same object.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate