Microsoft SQL Server 2005 XML

Articles and Columns

• Overview of Native XML Web Services for Microsoft SQL Server 2005
  Get an overview of how to set up and use XML Web Services using SOAP/HTTP inside SQL Server 2005. Illustrative examples are included. To get the most from this paper, you should have a basic understanding of Web service technologies including HTTP, SOAP, and WSDL.
• Performance Optimizations for the XML Data Type in SQL Server 2005
  Learn about performance optimizations for the XML data type in SQL Server 2005. This paper covers several ideas to improve query and data modification performance of XML data type in SQL Server 2005. To get the most value from this paper, you need familiarity with the XML features in SQL Server 2005
• Processing XML Showplans Using SQL CLR in SQL Server 2005
  Build an application to extract a query's estimated execution cost from its XML showplan. Users can submit only those queries costing less than a predetermined threshold to a server running SQL Server 2005, thereby ensuring it is not overloaded with costly, long-running queries.
• XML Best Practices for Microsoft SQL Server 2005
  Get the latest guidelines for XML data modeling and usage in SQL Server 2005 to help you develop rich applications for semi-structured and unstructured data management.
• XML Indexes in SQL Server 2005
  Use the relational query engine in SQL Server 2005 to make a single query plan for the SQL and XQuery parts of your queries, and make the implementation of XML queries fast and easy to predict and tune.
• XML Options in SQL Server 2005
  Three options for handling XML data in the Visual Studio 2005/SQL Server 2005 environment are discussed, including usage scenarios and guidelines to help you choose between them.
• XML Support in Microsoft SQL Server 2005
  This article discusses the XML support built into SQL Server 2005. It shows how this support integrates with the client-side programming support in the .NET Framework 2.0 and in native code such as OLEDB and SQLXML.
• What's New with FOR XML in SQL Server 2005
  This article details the major new capabilities of the server-side FOR XML clause in the next version of SQL Server. These enable you to further enhance the XML support in your applications and to write easy-to-maintain relational data-to-XML aggregations.