Is the IAM page allocated in the unified zone or in the hybrid zone? I will not talk about the role of the IAM page here. The tools used in many articles on the Internet: Check the internal data page plug-in InternalsViewer to create four tables first, heap table, clustered index table, non-clustered index table, clustered index and non-clustered index table 1 USEmasterIAM
Is the IAM page allocated in the unified zone or in the hybrid zone? I will not talk about the role of the IAM page here. The tools used in many articles on the Internet: Check the interinternal data page plug-in Internals Viewer to create four tables first, heap table, clustered index table, non-clustered index table, clustered index and non-clustered index table 1 USE master IAM
Is the IAM page allocated in the unified zone or in the hybrid zone?
I will not talk about the role of the IAM page here. There is a lot of information on the Internet.
Tools used in this article: view the interinternal Data Page's small plug-in Internals Viewer
Create four tables: heap table, clustered index table, non-clustered index table, clustered index and non-clustered index table.
1 USE master IAMDB IAMDBheaptable (c1 int identity (5000), c2 VARCHAR (5000) clusteredtable (c1 int identity (), c2 VARCHAR )) nonclusteredtable (c1 int identity (5000), c2 VARCHAR (5000) clusteredandnonclusteredtable (c1 int identity (), c2 VARCHAR () cix_clusteredtable) ix_nonclusteredtable) External) rows);) heaptable, 5000);) clusteredtable, 5000);) nonclusteredtable, 5000);) clusteredandnonclusteredtable, 5000) heaptable clusteredtable nonclusteredtable clusteredandnonclusteredtable,