Index Defrag Procedure - Michelle Ufford

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  January 31, 2012 at 9:40 am

  #254594

  Hi Guys

  I am using the Index Maintenance procedure by Michelle Ufford to look after my indexes.

  I have noticed in the output file, there are a few entries that say "We are unable to defrag this index" and in the next line, it defrags the index.

  Has anyone else seen this behaviour?

  Thanks

• johnitech.itech

  Hall of Fame

  Points: 3252

  More actions

  February 1, 2012 at 5:35 am

  #1441152

  😀

  Ok see below link

  http://technet.microsoft.com/en-us/library/cc966523.aspx

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  February 1, 2012 at 5:37 am

  #1441154

  That has nothing to do with the procedure