In Microsoft SQL Server 2000, indexing is the engine that makes your queries work with the most efficiency. Over time these indexes grow and contract, creating flaws that must be removed with a rebuilding process that should be part of your normal maintenance.
http://www.sqlservercentral.com/columnists/sjones/sqlserver2000indexing.asp
For many, maintenance of a SQL Server database is like pulling eyeteeth?not a priority.
https://www.techrepublic.com.com/5100-6268_11-5226728.html
[b]What is your current maintenance schedule for you SQL Server database? What procedures are in the plan?[/b]
