In many cases, when storing XML data, some of the elements/attributes will be more important for storage/querying than others. Access to values inside XML data-type instances requires additional overhead when compared with just selecting relational data...

A common requirement for formatting XML output from XQuery expressions, is to be able to add a style-sheet declaration. Style-sheet declarations consist of a standard processing-instruction node that appears at the top-level of the XML. In the following...

Michael Rys (a program manager for XML technologies in SQL Server 2005) recently gave a webcast for MSDN where he covers some of the details of the new native XML data type. He gives details of basic usage, static typing, DML and indexing. Michael also...

I have added a new section under my links that points to useful whitepapers dealing with XQuery and/or XML inside SQL Server 2005. These articles contain a lot of useful details on the system and I would recommend that everyone using (or planning on using...

I just reviewed the web cast of a presentation given by one of our program managers here in the SQL Server XML team. It gives a good overview of the various features of our native XML data type, including insertion, indexing, DML and schema binding. If...

There are several tricky issues around the serialization of special XML characters inside SQL Server 2005. This was highlighted to me earlier today when I had a question about how to output a URL value that caontains an ampersand (' & ') character...