Update Statistics

DECLARE @tabs TABLE (  id int identity(1,1) not null

                     , tabname sysname not null );

DECLARE @i int

      , @tabname sysname;
   INSERT INTO @tabs ( tabname )

        SELECT name

          FROM sysobjects

         WHERE type = ‘U’;
SELECT @i = max(id) FROM @tabs;
WHILE @i > 0

 BEGIN

   SELECT @tabname = tabname FROM @tabs WHERE id = @i

   PRINT ‘UPDATE STATISTICS ‘ + @tabname + ‘ WITH ALL’

   SET @i = @i – 1

 END;
GO