Home Forums SQL Server 2005 SQL Server 2005 General Discussion Index Types and Primary Keys versus Space Used RE: Index Types and Primary Keys versus Space Used

  • February 20, 2009 at 1:05 pm

    #947830

    Steve Jones - Editor (2/20/2009)

    SQL does mark the physical records in a heap, AFAIK, with something to be sure they are unique.

    RID (Row Identifier). An 8 byte combination of File ID, Page ID and Slot Index. It's stored in nonclusters as the row's address, not in the heap itself.

    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