only My site

Friday, February 10, 2012

ReIndexing Database Tables and Update Statistics on Tables

EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
GO
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)