|
|
Posted by SQLMan_25 on 11/22/06 21:18
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
Navigation:
[Reply to this message]
|