Post reply

Remove data base file fragmentation?

  • January 16, 2008 at 8:37 am

    #120110

    What option (GUI Options) or sql command can be used to remove fragmentation from Inserts, Updates and Deletes? (SQL Server 2000 on Windows 2003.) Is this done at the page level?

    Thanks, Kevin

  • January 16, 2008 at 9:29 am

    #768766

    Rebuilding the indexes will remove fragmentation. Look at DBCC SHOWCONTIG

  • January 16, 2008 at 9:42 am

    #768785

    Does fragmentation only occur at the index level? Does it occur at the non-indexed table level? Can the database files (.mdf) become fragmented?

    Thanks, Kevin

  • January 22, 2008 at 1:35 pm

    #770645

    Yes, data files can also be fragmented. You need to use a defrag software to defrag it like any other operating system files.

    _____________
    Donn Policarpio

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply