Post reply

Question for all who are interested in learning IAM

  • January 27, 2010 at 2:01 am

    #215920

    Question for all who are interested in learning IAM

    IAM is basically a roadmap for heap's data pages. Then why do we call this Index Allocation Map.

    In sql2005 onwards this has started allocating INCLUDE columns for non clustered index, BLOB and row over flow data etc as well.

  • January 27, 2010 at 7:29 am

    #1109287

    Is there a question here?

    IAM is basically a roadmap for heap's data pages.

    Not just heaps.

    In sql2005 onwards this has started allocating INCLUDE columns for non clustered index, BLOB and row over flow data etc as well.

    Include columns aren't reflected in, nor do they affect IAM 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply