If the bit is 1, the extent it represents is allocated to the allocation unit owning the iam page 如果这个位是1,它所代表的区将被分配给拥有该iam页的分配单元。
Table uses all three allocation unit types, because it contains both data and text image page types 表使用所有三个分配单元类型,因为表中包含data和text/image页类型。
An allocation unit is a collection of pages within a heap or b-tree used to manage data based on their page type 分配单元是堆或b树内用于根据页类型管理数据的页集合。
In-row data, lob data, and row-overflow data represent the three allocation units that make up a partition 行内数据、lob数据以及行溢出数据表示构成分区的三个分配单元。
For large object data, one row is returned for the lob data allocation unit of each partition 对于大型对象(lob)数据,针对每个分区的lob_data分配单元返回与其对应的一行。
The function traverses the page chains for the allocation units that make up the specified partitions of the table or index 此函数将遍历构成表或索引的指定分区的分配单元页链。
A fragment is made up of physically consecutive leaf pages in the same file for an allocation unit 碎片由分配单元中同一文件内的物理连续的叶级页组成。一个索引至少有一个碎片。
Columns that have existing data in the row overflow data allocation unit . if a clustered index is created on a 聚集索引的索引键不能包含在row_overflow_data分配单元中具有现有数据的
An index allocation map page maps the extents in a 4-gigabyte part of a database file used by an allocation unit 索引分配映射(iam)页将映射分配单元使用的数据库文件中4gb部分中的区。
Table is later modified to include a lob data type column, a lob data allocation unit is created to manage that data 表修改为包含lob数据类型列,将创建一个lob_data分配单元来管理该数据。