Author : Aamir Hasan
Solution :ReIndexing Database Tables, turned out to be a defragmented table.DBCC DBREINDEX is efficient over dropping and recreating indexes.
USE MyDatabase
GO
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
GO
EXEC sp_updatestats
Author:
Aamir Hasan औथोर:
आमिर हसन أثر
أمير حسن .
71fa1608-7627-4f7f-97b0-ae53f50853ca|0|.0
ALL, SQL 2005 & 2008
dbcc, sql,