Performance Optimizations for the XML Data Type in SQL Server 2005

Performance Optimizations for the XML Data Type in SQL Server 2005: "Performance Optimizations for the XML Data Type in SQL Server 2005

Shankar Pal, Babu Krishnaswamy, Vasili Zolotov, and Leo Giakoumakis
Microsoft Corporation
December 2005
Applies to:
Microsoft SQL Server 2005
XML Data Type
Summary: This paper explores several ideas to improve the query and data modification performance of the XML data type in Microsoft SQL Server 2005. To get the most value from this paper, you need to be familiar with the XML features in SQL Server 2005. For background material, see XML Support in Microsoft SQL Server 2005 and XML Best Practices for Microsoft SQL Server 2005 on the Microsoft Development Network (MSDN). (26 printed pages)"