Enjoy Every Sandwich

Thoughts on SQL, XML, .NET and sometimes beer.

<September 2008>
SuMoTuWeThFrSa
31123456
78910111213
14151617181920
21222324252627
2829301234
567891011


Navigation

Tools

List O'Links

Kent's Other Stuff

Subscriptions

News

Please read these
Notices and Disclamiers

Post Categories

Article Categories



Tuesday, August 17, 2004 - Posts

Clarification of XML Type Storage in SQL Server 2005

The Books-on-line for SQL Server 2005 makes this statement regarding the limitations of XML data:

The stored representation of xml data type instances cannot exceed 2 GB in size.

It's correct, but it could be clearer. You could read this as "all of the instances combined can't exceed 2 GB in size." or "any given instance cannot exceed 2 GB in size." Per Michael Rys, and some of my own testing, you can definitely have more than 2 GB of XML type data in a single table, but no single instance can exceed that limit.

posted Tuesday, August 17, 2004 8:08 AM by ktegels

Alter View, Create Function: Application XCopy Support with SQL Server 2005 Express

In this weeks edition of Alter View, Create Function I take a quick look at the marvel at is the application XCopy feature with SQL Server 2005 Express.

posted Tuesday, August 17, 2004 5:46 AM by ktegels




Powered by Dot Net Junkies, by Telligent Systems