http://www.sqlservercentral.com/Articles tagged XML posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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.http://www.sqlservercentral.com/redirect/articles/63710/2008/07/14http://www.sqlservercentral.com/redirect/articles/63710/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)http://www.sqlservercentral.com/redirect/articles/63709/2008/07/14http://www.sqlservercentral.com/redirect/articles/63709/This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML datahttp://www.sqlservercentral.com/redirect/articles/63703/2008/07/14http://www.sqlservercentral.com/redirect/articles/63703/This long running, and very popular, XML series continues with a look at building an ATOM feed with SQL Server.http://www.sqlservercentral.com/articles/XML/63535/2008/07/16http://www.sqlservercentral.com/articles/XML/63535/Michael David discusses how XQuery was designed from the ground up to process hierarchical XML data, but it is still missing capabilities that a hierarchical query processor product should have and did have originally.http://www.sqlservercentral.com/redirect/articles/63624/2008/07/14http://www.sqlservercentral.com/redirect/articles/63624/As XML has become a popular means to store data for ease of interoperability, how do we use LINQ to query XML data?http://www.sqlservercentral.com/redirect/articles/63530/2008/07/09http://www.sqlservercentral.com/redirect/articles/63530/Create a computed column in SQL Server using XML data and optimize SQL queries. Learn how to create a function for XQuery and use it within the computed column formula.http://www.sqlservercentral.com/redirect/articles/63445/2008/06/25http://www.sqlservercentral.com/redirect/articles/63445/This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features.http://www.sqlservercentral.com/redirect/articles/63190/2008/06/20http://www.sqlservercentral.com/redirect/articles/63190/SQL Server MVP Jacob Sebastian continues his very successful XML series with a foray into SQL Server 2000's XML capabilities for generating custom documents.http://www.sqlservercentral.com/articles/XML/63043/2008/06/04http://www.sqlservercentral.com/articles/XML/63043/Continuing on with his amazing series on XML, SQL Server MVP Jacob Sebastian shows us how to use XML in SQL Server 2005 to generate an ATOM feed.http://www.sqlservercentral.com/articles/XML/62931/2008/05/15http://www.sqlservercentral.com/articles/XML/62931/How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.http://www.sqlservercentral.com/articles/Reporting+Services/62731/2008/05/08http://www.sqlservercentral.com/articles/Reporting+Services/62731/Over the past few years, software developers have used various kinds of technologies to retrieve data from relational databases. SQL Server 2000 is the first Microsoft DBMS to fully support XML. In this article the author concentrates on the FOR XML clause in SQL Server versions, 2000 and 2005. Click on title for morehttp://www.sqlservercentral.com/redirect/articles/62916/2008/05/07http://www.sqlservercentral.com/redirect/articles/62916/Use XQuery scripting language to retrieve specific XML data type values in SQL Server. Learn to script and use Value() and Query() to retrieve single and multiple XML values.http://www.sqlservercentral.com/redirect/articles/62841/2008/04/24http://www.sqlservercentral.com/redirect/articles/62841/Send SQL query results as HTML-formatted e-mail using SQL Server Integration Services.http://www.sqlservercentral.com/articles/SSIS/62678/2008/04/23http://www.sqlservercentral.com/articles/SSIS/62678/Continuing on with part 18 of his series, MVP Jacob Sebastian examines building an RSS feed in T-SQL.http://www.sqlservercentral.com/articles/XML/62661/2008/04/09http://www.sqlservercentral.com/articles/XML/62661/Jacob Sebastian brings a little more complexity to working with XML documents. Here we learn how to iterate through a document and use each node and perform some action on each one.http://www.sqlservercentral.com/articles/XML/62290/2008/03/26http://www.sqlservercentral.com/articles/XML/62290/Continuing on with his series, Jacob Sebastian shows how you can shape the query results to a certain pre-defined XML structure in this article.http://www.sqlservercentral.com/articles/XML/62289/2008/03/19http://www.sqlservercentral.com/articles/XML/62289/The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.http://www.sqlservercentral.com/articles/XML/62054/2008/03/12http://www.sqlservercentral.com/articles/XML/62054/SQL Server 2005 has greatly expanded the XML capabilities of this platform, but should you use it in your database? New author and MVP Simon Munro brings us a look at how he has used XML and where it might fit in your database. http://www.sqlservercentral.com/articles/Miscellaneous/2920/2008/03/11http://www.sqlservercentral.com/articles/Miscellaneous/2920/By adding XML-based documentation capability to your SQL code, you can automatically extract and format tagged comments into a complete API documentation set for your SQL libraries. http://www.sqlservercentral.com/redirect/articles/62140/2008/02/20http://www.sqlservercentral.com/redirect/articles/62140/Continuing on with his comprehensive series on XML, Jacob Sebastian shows us how to generate a tree of parent-child data using XML.http://www.sqlservercentral.com/articles/61821/2008/02/13http://www.sqlservercentral.com/articles/61821/Learn performance impacts of the XML data type and VARCHAR (MAX) data type in SQL Server 2005. Here are storage, I/O and CPU results of XML in SQL Server.http://www.sqlservercentral.com/redirect/articles/62137/2008/02/08http://www.sqlservercentral.com/redirect/articles/62137/Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page. http://www.sqlservercentral.com/articles/XSL/2831/2008/01/28http://www.sqlservercentral.com/articles/XSL/2831/This article will quickly dive head first right into XML. http://www.sqlservercentral.com/articles/Basics/20010422115709/78/2008/01/04http://www.sqlservercentral.com/articles/Basics/20010422115709/78/Continuing on with his highly popular XML series, Jacob Sebastian looks at variable content and stylesheets in your SQL content.http://www.sqlservercentral.com/articles/XML/61462/2007/12/19http://www.sqlservercentral.com/articles/XML/61462/Ivan Pepelnjak describes a few ways to extract data from SQL databases and serve it to an AJAX application running in a web browser.http://www.sqlservercentral.com/redirect/articles/61633/2007/12/19http://www.sqlservercentral.com/redirect/articles/61633/This white paper consolidates general information, best practices, and tips for designing Microsoft SQL Server Reporting Services (SSRS) reports. It is intended to provide a starting point for design questions and an overview of some of the capabilities of Reporting Services.http://www.sqlservercentral.com/redirect/articles/61647/2007/12/13http://www.sqlservercentral.com/redirect/articles/61647/Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.http://www.sqlservercentral.com/articles/XML/61618/2007/12/05http://www.sqlservercentral.com/articles/XML/61618/Use familiar XML markup to extend the capabilities of your relational database.http://www.sqlservercentral.com/redirect/articles/61631/2007/12/05http://www.sqlservercentral.com/redirect/articles/61631/Have you ever received an XML file from someone to import into SQL Server? It's not as easy as you might expect, especially in SQL Server 2000. New author Steve Moore brings us an article and code on how to do just that. http://www.sqlservercentral.com/articles/Miscellaneous/importingxmlfilesintosqlserver/2262/2007/11/23http://www.sqlservercentral.com/articles/Miscellaneous/importingxmlfilesintosqlserver/2262/