Blog / Blog Article: Don’t Forget to Maintain Your Indexes

Don’t Forget to Maintain Your Indexes

Indexing | August 8, 2009 | 3:22 am

So long as data is inserted, updated and deleted from tables, indexes will become fragmented over time, and performance will suffer. Index maintenance is vital to keeping databases and their users happy. In this article, I go through the key index maintenance tasks and identify more essential areas that are a DBA’s duty to maintain. Read more…

Be Sociable, Share!
    Related posts:
    1. Don’t Make Dumb Mistakes by Duplicating Indexes
    2. How Do You Defragment Your SQL Server Indexes
    3. Free T-SQL Database Maintenance Scripts
    4. Don’t Forget to Sign Up for the 24 Hours of PASS: Summit Preview
    5. Brad’s Sure Guide to Indexes
    Copyright 2009-2011 Brad M McGehee