reguitti (12/5/2012)
I use the commandDBCC DBREINDEX(MOV_MAG,' ')
That's deprecated and has been for about 7 years. Look up ALTER INDEX
The thing which is giving me some perplexity is that before the upgrade to a new version of the software which is using this DB, there was a complete maintenance plan, running every week (also with reindex) and it was enough for the DB, and the DB has worked flawlessly for more than ten years.
Data growth.
As I said earlier, I doubt the problem is fragmentation. Far more likely to be statistics-related.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability