Question for all who are interested in learning IAM

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Question for all who are interested in...

Question for all who are interested in learning IAM

Rate Topic

Display Mode

Topic Options

Author

Message

luckysql.kinda

Posted Wednesday, January 27, 2010 2:01 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 10:41 PM
Points: 310, Visits: 649

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.

Post #854231

GilaMonster

Posted Wednesday, January 27, 2010 7:29 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:30 AM
Points: 37,742, Visits: 30,021

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 2008, MVP
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

Post #854384

« Prev Topic | Next Topic »

Permissions