Is it possible to force FULLSCAN
when statistics are updated automatically by SQL Server 2008 R2?
If not, is a planned UPDATE STATISTICS WITH FULLSCAN
the best way to keep statistics up-to-date?
note: The need for the FULLSCAN
comes by proved suboptimal plan generation when using non-FULLSCAN
statistics.
In the end, it looks like it's not possible (see my last comment on the question for details).