Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth RE: Stairway to Transaction Log Management in SQL Server, Level 7: Dealing with Excessive Log Growth

  • November 28, 2012 at 2:23 am

    #1562984

    Simon-413722 (11/28/2012)

    Index rebuilds

    Rebuilding an index offline, using ALTER INDEX REBUILD (or the deprecated DBCC DBREINDEX in SQL Server 2000) drops the target index and rebuilds it from scratch (online index rebuilds do not drop the existing index until the end of the rebuild operation).

    Hi Gail,

    I copied and paste above paragraph from the article.

    Urgh... looks like I missed that in tech-editing (Tony wrote this article, I checked it for errors). I will set an appropriate penance and fix it later.

    Sorry, I misunderstood where you read what from. Paul is, of course, correct.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass