If you migrate from SQL Server 2000 to SQL Server 2005, probably the database indexes had to be rebuild again.
This is the script to do that:

USE database_name
GO
EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 80)”
GO
EXEC sp_updatestats
GO

Advertisements