How to improve the speed of a heavily fragmented table?
We have a SQL 2000 database with several tables. During a day these tables have LOTS of SELECT / UPDATE / INSERT commands. Our system is beginning to be VERY slow so I thought i would investigate why this could be. After a bit of reading i researched into table indexes. Worryingly one of the most searched tables had this DBCC SHOWCONTIG info;