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

  • Is the file having to grow in order to get the load done? That's the most likely cause of the slow-down.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon