22 March,2013 by Jack Vamvas
sp_updatestats executes UPDATE STATISTICS against all the tables on a database, that require an update. Sp_updatestats accepts the @resample argument. This forces the UPDATE STATISTICS resample option.
Using RESAMPLE updates the statistics based on the latest sample rate. To view the latest sample rate use the DBCC SHOW STATISTICS command.
use db_name go DBCC SHOW_STATISTICS('a_table',a_statistic)
If RESAMPLE is not used , UPDATE STATISTICS based on a sample default rate. The sample default rate is determined by SQL Server .
Deciding on which method to use is dependant on the level of granular control required.