what is the fragmentation

• RKGoriparthi

  SSC Veteran

  Points: 240

  More actions

  November 6, 2009 at 4:54 am

  #136113

  what is the fragmentation

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  November 6, 2009 at 4:59 am

  #1075826

  Start here: DBCC INDEXDEFRAG

  (All your concurrent general questions sound like interview questions...)

• Paul White

  SSC Guru

  Points: 150467

  More actions

  November 6, 2009 at 8:03 pm

  #1076210

  DBCC INDEXDEFRAG is deprecated, so I prefer the information found here:

  http://msdn.microsoft.com/en-us/library/ms188917.aspx

  Paul

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi