Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » XML   (RSS)
Wednesday, September 27, 2006 1:09 AM

XML: Typed and Untyped

Occasionally we hear from people who are surprised to find that their XML data uses more space when typed than when untyped. In general, this is to be expected. Typed XML has some advantages over untyped XML, namely smarter query plans and the ability
Posted by brandon.berg | 3 Comments
Filed under: ,
Tuesday, May 23, 2006 10:33 PM

XML Data Type Limitations

I'd like to take some time today to explain some of the seemingly arbitrary limits placed on the XML data type, specifically those related to ID/IDREF validation, complex XML Schema types, the depth limit for XML data, and the enigmatic "XSD schema too
Posted by brandon.berg | 4 Comments
Filed under: ,
Monday, April 24, 2006 10:30 PM

Check Out Denis Ruckebusch's Blog

I'm adding a link in the sidebar to Denis Ruckebusch's blog . Denis is one of our testers for the XML data type, and he has two recent posts worth reading if you use XML in SQL Server 2005. The first explains how to modify a schema to work around some
Posted by brandon.berg | 1 Comments
Filed under: ,
Monday, April 24, 2006 10:09 PM

Dealing with the Limitations of XSD Content Models

There was recently a question on an internal mailing list about how to model RSS 2.0 with XML Schema. The short answer is that it can’t be done. The problem lies with the content model of the <channel> element, which consists of three elements which
Posted by brandon.berg | 1 Comments
Filed under: ,
Thursday, April 13, 2006 3:04 PM

An article on FOR XML in Microsoft SQL Server 2000 and 2005

I just posted an article What does server side FOR XML return? ( http://blogs.msdn.com/sqlprogrammability/articles/576095.aspx ) which gives some details of the design and performance characteristics of various FOR XML flavors. I also added links to XML
Posted by ekogan | 0 Comments
Thursday, April 13, 2006 2:44 PM

What does server side FOR XML return?

XML publishing functionality exposed as “FOR XML” in Microsoft SQL Server 2000 evolved quite a bit in SQL Server 2005. So, I thought I would document the matrix of what FOR XML results in. This article should help understand some performance characteristics
Posted by ekogan | 1 Comments
Monday, April 03, 2006 10:39 PM

Name resolution, default schema, implicit schema Part II

Last section clarified some background, let us continue with Name Resolution Algorithm for Types and XML Schema Collections [Algorithm] As implied by general syntax for referencing entities, types or XML schema collections cannot be referenced across
Posted by andrewz | 0 Comments
 
Page view tracker