• The solution is:

    1) not to use maintenance plans

    2) add FULLSCAN

    3) write a better script (Hint: there are lots out in SSC)

    Some best practices:

    1) do not try to defragment heaps

    2) do not defragment indexes with less than 8 pages (1 extent)

    3) do defragment the index if it is more than 10% fragmented

    4) do reindex if the index is more than 30% fragmented

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."