Home Forums SQL Server 2005 Administering Defragmenting a MDF file increasing allocated free space RE: Defragmenting a MDF file increasing allocated free space

  • Darren.Siegert (3/26/2009)


    The database is a reporting mart which gets loaded with approx 200,000 records every night.

    With that kind of inserts I would drop and create them. Check the fragmentation levels after the inserts and then you can either decide to rebuild them or drop&create the indexes.