XML Best Practices for Microsoft SQL Server 2005

Learn about the guidelines for XML data modeling and usage in Microsoft SQL Server 2005, and see illustrative examples. To get the most from this article, you should have a basic understanding of XML features in SQL Server; for background material, see XML Support in Microsoft SQL Server 2005 on the Microsoft Developer Network

http://technet.microsoft.com/en-gb/library/ms345115.aspx