XML Data type storage

[SQLMan_25]

Hi All,

As per BOL, XML data type can store up 2 GB of data.
My question is when a row is inserted in a table, for its xml column,
2GB of space will be resered.
In other words, how xml is internally stored. Is storage allocation is
similar to varchar(max) data type?

Thanks in advance for everything.

[SQLMan_25]

SQLMan_25 wrote:

Hi All,

As per BOL, XML data type can store up 2 GB of data.
My question is when a row is inserted in a table, for its xml column,
2GB of space will be resered.
In other words, how xml is internally stored. Is storage allocation is
similar to varchar(max) data type?

Thanks in advance for everything.

Found the answer for my question on msdn:

In-row and out-of-row storage
Small XML data type instances are stored within the rows of a table.
Larger values that cannot be accommodated within a disk page are stored
out of row with an in-row pointer of 16 bytes.

Regards,
NH