PERSIST_SAMPLE_PERCENT

[allenjkrehbiel]

Description of the feature
It can be a new feature, or a change to an existing feature

Include support for PERSIST_SAMPLE_PERCENT to the UPDATE STATISTICS command.

We are utilizing this process to force a higher percentage sample size for statistics in certain tables of our DB. (Some tables 30%, some tables FULLSCAN).

We also have auto update stats enabled in this environment.

When stats are auto updated, the sample size reverts back to a SQL default.
UPDATE STATISTICS offers the parameter PERSIST_SAMPLE_PERCENT to force the same sample size for any subsequent stats updates that do not specify a sample size.