SQL Server Statistics Maintenance Job

sp_MSforeachdb @command1='
USE ?;
IF NOT ("?" IN ("model","msdb","master","tempdb")) 
BEGIN
   EXEC sp_createstats;
   DECLARE @tbls TABLE (rowId INT IDENTITY(1,1), tblschema NVARCHAR(128), tblname NVARCHAR(128));
   DECLARE @stmt NVARCHAR(2000), @rowId INT, @maxRowId INT, @tblschema NVARCHAR(128), @tblname NVARCHAR(128);
   INSERT INTO @tbls (tblschema, tblname) 
   SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_type="BASE TABLE";
   SELECT @rowId = MIN(rowId), @maxRowId = MAX(rowId) FROM @tbls;
   WHILE  @rowId <= @maxRowId 
      BEGIN
         SELECT @tblschema = tblschema, @tblname = tblname FROM @tbls WHERE rowId = @rowId;
         SET @stmt = "UPDATE STATISTICS " + "[" + @tblschema + "].[" + @tblname + "];"; 
         PRINT "?: " + @stmt;
         EXECUTE (@stmt);
         SET @rowId = @rowId + 1;
      END
END
';

sqlcmd -S PRIVATE-E3A52F5\SS1 -E -i create_update_statistics.sql -o create_update_statistics.out
notepad.exe create_update_statistics.out

Labels: SQL Server, Statistics