SET NOCOUNT ON
DECLARE @SQLcommand NVARCHAR(512),
@Table SYSNAME
DECLARE CurAllTables CURSOR FOR
SELECT table_schema + '.' + table_name
FROM information_schema.tables T
INNER JOIN sys.sysindexes SSI
ON t.TABLE_NAME = object_name(ssi.id)
WHERE SSI.rowcnt > 500
AND SSI.NAME LIKE '%_EN'
OPEN CurAllTables
FETCH NEXT FROM CurAllTables
INTO @Table
WHILE (@@FETCH_STATUS = 0)
BEGIN
PRINT N'UPDATING STATISTICS FOR TABLE: ' + @Table
SET @SQLcommand = 'UPDATE STATISTICS ' + @Table + ' WITH FULLSCAN'
EXEC sp_executesql @SQLcommand
FETCH NEXT FROM CurAllTables
INTO @Table
END
CLOSE CurAllTables
DEALLOCATE CurAllTables
SET NOCOUNT OFF
GO