• Every week a rebuild index is being run on the databas that is about 40GB.

    Is this running with SORT_IN_TEMPDB ON?

    But then over a night the size jump up to 42 GB.

    And during that time the only thing that has happen is the same thing that

    has happend every night.

    Are you talking about rebuild index or some other activity, can you specify.

    Regards
    Durai Nagarajan