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 :-)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!