Discussion Locked

SQL Server maintenance

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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]

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.