Home > IT Answers > SQL Server > FirstIAM page of a table in SQL Server 2005
JudeAj
5 pts.
 FirstIAM page of a table in SQL Server 2005
SQL Server 2005, SQL Server tables
Hi, Can you please explain how is the "FirstIAM page of a table" is calculated in the sysindex view, in SQL server 2005. Is is stored in some system table or is it calculated every time a table is accessed? Pardon me if this sounds to be a stupid question.I am new to SQL server 2005 :-)

Software/Hardware used:
ASKED: June 12, 2009  2:22 PM
UPDATED: June 14, 2009  6:08 AM
RELATED QUESTIONS
Answer Wiki:
That value points to the physical page on the disk. It would be placed into the system when the table is first created.
Last Wiki Answer Submitted:  June 14, 2009  6:08 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _