/***********************
重建数据库表所有统计信息
2012-06-12
先选择要修复的数据库
***********************/
DECLARE @name NVARCHAR(255)
--所有用户表游标
DECLARE authors_cursor CURSOR
FOR
SELECT [name]
FROM sys.objects
WHERE type = 'U'
ORDER BY object_id
OPEN authors_cursor
FETCH NEXT FROM authors_cursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT '正在更新表[' + @name + ']的统计信息'
EXEC ('UPDATE STATISTICS ['+@name+'] ');
-- Get the next author.
FETCH NEXT FROM authors_cursor INTO @name
END
CLOSE authors_cursor
DEALLOCATE authors_cursor
GO
重建数据库表所有统计信息
2012-06-12
先选择要修复的数据库
***********************/
DECLARE @name NVARCHAR(255)
--所有用户表游标
DECLARE authors_cursor CURSOR
FOR
SELECT [name]
FROM sys.objects
WHERE type = 'U'
ORDER BY object_id
OPEN authors_cursor
FETCH NEXT FROM authors_cursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT '正在更新表[' + @name + ']的统计信息'
EXEC ('UPDATE STATISTICS ['+@name+'] ');
-- Get the next author.
FETCH NEXT FROM authors_cursor INTO @name
END
CLOSE authors_cursor
DEALLOCATE authors_cursor
GO