Simple Research on the LOB page in SQLSERVER

The LOB page in SQLSERVER is a simple study. This article is complementary to my other article, before reading the article "Simple Research and Test of SQLSERVER2012 column storage Index", I hope you can read this article o (_) first (_) I believe everyone will be familiar with the simple research and test of the oSQLSERVER2012 column storage index.

The LOB page in SQLSERVER is a simple study. This article is complementary to my other article, before reading the article "Simple Research and Test of SQLSERVER2012 column storage Index", I hope you can read this article o (_) first (_) o SQLSERVER2012 simple research and test of column-store index LOB page I believe everyone will not be unfamiliar, LOB dedicated to storage of large

Simple Research on the LOB page in SQLSERVER

This article and my other article complement each other. before reading the article "Simple Research and Test of SQLSERVER2012 column storage Index", I hope you can read this article o (objective _ testing) first) o

Simple Research and Test on column-store index of SQLSERVER2012

LOB pages are not unfamiliar to everyone. LOB stores large object data. Data types such as text and image are stored on the LOB page.

The MSDN explanation is as follows:

(V = SQL .105). aspx

LOB_DATA: one or more of the following types of data are stored for large objects: text, ntext, image, xml, varchar (max), nvarchar (max ),

Varbinary (max) or CLR user-defined type (clr udt ). The page type is Text/Image.

LOB_DATA allocation Unit

When a table or index has one or more LOB data types, a LOB_DATA allocation unit is allocated to each partition. The Hong Kong server manages the storage of the data.

LOB data types include text, ntext, image, xml, varchar (max), nvarchar (max), varbinary (max), and CLR user-defined types.

However, this explanation is provided in the result of dbcc ind.

PageType page type: 1: Data Page; 2: Index page; 3: Lob_mixed_page; 4: Lob_tree_page; 10: IAM page

What is the difference between Lob_mixed_page and Lob_tree_page?

Heap table

Execute the following SQL statement: the Hong Kong virtual host and the Hong Kong virtual host to store the results of DBCC IND.

---- DBCCResult (8 PageFID NVARCHAR (200), 9 PagePID NVARCHAR (200), 10 iamfid nvarchar (200), 11 iampid nvarchar (200), 12 ObjectID NVARCHAR (200 ), 13 IndexID NVARCHAR (200), 14 PartitionNumber NVARCHAR (200), 15 PartitionID NVARCHAR (200), 16 iam_chain_type NVARCHAR (200), 17 PageType NVARCHAR (200 ), 18 IndexLevel NVARCHAR (200), 19 NextPageFID NVARCHAR (200), 20 NextPagePID NVARCHAR (200), 21 PrevPageFID NVARCHAR (200), 22 PrevPagePID NVARCHAR (200) 23)