SQL Server Performance

Fragmentation Presentation

Discussion in 'Contribute Your Performance and Clustering Tips' started by Twan, Jan 25, 2004.

  1. Twan New Member

    A presentation at the UK SQLServer Users Group explained a lot about fragmentation both on the disks themselves and within SQL. One of the interesting facts shown was that doing a DBCC DBREINDEX followed by a DBCC SHRINKDB causes the level of fragmentation to be returned to pretty much what was there before the DBCC DBREINDEX

    the url is www.sqlserverfaq.com under events there is UKSSUG Night School 15 Oct 2003. This contains a powerpoint presentation and some examples... unfortunately the presentation notes are in a subscribed area... subscription is free, and it is also a good SQL site


    Cheers
    Twan

Share This Page