Hi. First I am new to this so pardon if this is a dumb question.
Trying to understand the difference between updating statistics using these two commands:
UPDATE STATISTICS tblname WITH FULLSCAN ALL
and
EXEC sp_updatestats 'resample'
I understand the first would do a full scan of the table and take more resources (right?) and the second would do a resampling; however, can you please explain when would it make sense to use one versus the other method?
Thanks!