Solved

Is XML datatype exempt from 8,060 bytes-per-row limit?

Posted on 2006-06-14
2
193 Views
Last Modified: 2012-08-14
Well?  Is it?

The maximum size of an XML-type field is 2 to the 31st power.  I'm not a math major, but I think that's quite a bit bigger than 8,060.  Can I trust that XML fields are automatically stored differently, similar to varchar(MAX)?  (Thanks, MikeWalsh!)

Thanks again,
BrianMc1958
0
Comment
Question by:BrianMc1958
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 125 total points
ID: 16906809
XML is a single field. so, for the row, only few bytes (12) are stored in the row for the pointer, the actual data is stored apart.
similary to varchar(max), you can store up to 2GB of data in such a single field.

0
 

Author Comment

by:BrianMc1958
ID: 16911027
Great.  Thanks.  
--BrianMc1958
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
export sql results to csv 6 34
Webservices in T-SQL 3 30
SQL View nearest date 5 35
performance query 4 20
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question