• Robert is right, the quote is not quite the same as in the book. The following email will explain the difference 😉

    --**********************************************************************************

    Hi Brandon

    Of course you can publish this note. I would suggest a minor edit to your last sentence:

    When the clustered index is created, it does in fact reorder the data physically on disk according to the cluster key, or as close to physical order as possible given the available space. After that, maintaining the clustered index is a logical operation. Rebuilding the index will again order the data physically. Reorganizing the index is an attempt to make the logical and the physical order match, without all the work of rebuilding the index.

    Best regards,

    Kalen Delaney, SQL Server MVP

    http://www.SQLServerInternals.com