How do you reorganize your index, once you find the problem?

You can reorganize your index using “DBCC DBREINDEX”. You can either request a particular index to be re-organized or just re-index the all indexes of the table. This will re-index your all indexes belonging to “HumanResources.Department”.
DBCC DBREINDEX ([HumanResources.Department])
This will re-index only “AK_Department_Name”.
DBCC DBREINDEX ([HumanResources.Department],[AK_Department_Name])
This will re-index with a “fill factor”.
DBCC DBREINDEX ([HumanResources.Department],[AK_Department_Name],70)
You can then again run DBCC SHOWCONTIG to see the results.