Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012
    Posts
    133

    Unanswered: maintenance plan primary key

    Hi guys,
    do i need to create maintenance plan for particular tables with only primary constraint exist. The tables perform moderate insert, update and detele. any inputs much appreciated.

    TIA

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    If downtime is not a problem and you don't mind the idea of rekeying data, then maintenance is probably optional. Yes, you need to at least do the DBCC checks on every user database that gets changes (insert/update/delete) of any kind.

    If you have indexes of any kind (user created, DRI created, other), then those need maintenance too.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •