General discussion

  • Creator
    Topic
  • #2277849

    SQL Server maintenance

    Locked

    by Mark W. Kaelin ·

    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.

    http://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]

All Comments