Home Forums SQL Server 2005 Administering Does rebuilding a clustered index effect non clustered index. RE: Does rebuilding a clustered index effect non clustered index.

  • December 2, 2011 at 9:06 am

    #1415987

    george sibbald (12/2/2011)

    http://sqlskills.com/BLOGS/PAUL/post/Search-Engine-QA-19-Misconceptions-around-index-rebuilds-(allocation-BULK_LOGGED-mode-locking).aspx

    The line that I am most interested in is:

    "The first few service packs of 2000 had bugs that changed the behavior of rebuilding unique clustered indexes back and forth - this is the source of much of the confusion around this myth."

    I have seen with my own eyes the non-clustered indexes rebuilt during a DBCC DBREINDEX, it said it was rebuilding them. I'm guessing that it was during one of these back and forths that so clearly comes to mind.. And is the source of my confusion, its hard to agree with something when personal experience utterly contradicts what is being said. As for SQL 2005+ I have no issues..

    CEWII