Home Forums Data Warehousing Integration Services Data Transfer - data not transfered in order RE: Data Transfer - data not transfered in order

  • July 22, 2013 at 10:41 am

    #1634576

    wolfkillj (7/22/2013)

    So strictly speaking, the data for rows in a clustered index will not always be physically stored in key order, although the data can only be out of order within a page.

    The pages can be out of physical order too, it's called fragmentation (logical order of pages doesn't match physical order of pages)

    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