• Steve. The number of indexes will definitely contribute to growth. The only way I have ever found out the main culprits is by taking a copy of the database BEFORE you run any reorganisation jobs and then reindex each index in turn whilst monitoring the stats. I know this is cumbersome but it will give an explicit result to work with.

    However, even if you find the main offendor there is not a lot you can do other than index less frequently or expand the fill factor. What Microsoft need to do is give the option of reducing the amount of logging during re-indexing. A felow dba received a negative reply when he raised this as an issue with them.

    I have tried setting the db to bulk logging mode during reindexing but this only cuts down the log by about 25%. Every little helps I suppose.


    ------------------------------
    The Users are always right - when I'm not wrong!