Home Forums SQL Server 2005 Administering Reindex - does it make data contiguous, space permitting RE: Reindex - does it make data contiguous, space permitting

  • Let me restate my question.

    After moving some huge tables to their own file groups, I will end up with five files in the primary file group with about 95% free space containing about 200 tables with a total of about 15 million rows.

    I want to reduce the primary file group to a single file with a reasonable amount of space.

    How should I proceed.