Sp_updatestats - TSQL Tutorial

On Transact SQL language the sp_updatestats is part of Database Engine Stored Procedures and runs update statistics against all tables in the current database.

Sp_updatestats syntax:

sp_updatestats [ @resample = 'resample'] ;


Sp_updatestats example 1:

USE model;
GO
EXEC sp_updatestats;
GO

Sp_updatestats example 2:

USE model;
GO
EXEC sp_updatestats @resample = 'resample';
GO