InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 05:27:41 GMT20http://www.sqlservercentral.com/Forums/Topic854231-391-1.aspxIs there a question here?[quote]IAM is basically a roadmap for heap's data pages.[/quote]Not just heaps.[quote]In sql2005 onwards this has started allocating INCLUDE columns for non clustered index, BLOB and row over flow data etc as well.[/quote]Include columns aren't reflected in, nor do they affect IAM pages.Wed, 27 Jan 2010 07:29:54 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic854231-391-1.aspxQuestion for all who are interested in learning IAMIAM 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.Wed, 27 Jan 2010 02:01:17 GMTluckysql.kinda