SQL XML Archives - Page 3 of 3 - SQL Authority with Pinal Dave

SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache

March 17, 2009

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Database, SQL Scripts, SQL Utility, SQL XML

I am very fortunate that I have friends like Michael Coles. Michael Coles is SQL Server and XML expert and have written many books on SQL Server as well XML. He has previously written book which I have reviewed on this blog SQLAuthority News – Book Review – Pro T-SQL…

SQL SERVER – Simple Example of Reading XML File Using T-SQL

February 13, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL XML

In one of the previous article we have seen how we can create XML file using SELECT statement SQL SERVER – Simple Example of Creating XML File Using T-SQL. Today we will see how we can read the XML file using the SELECT statement. Following is the XML which we…

SQL SERVER – Simple Example of Creating XML File Using T-SQL

February 12, 2009

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL XML

I always want to learn SQL Server and XML file. Let us go over a very simple example, today about how to create XML using SQL Server.

SQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005

February 11, 2009

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, MVP, SQL Index, SQL XML

I always wanted to learn XML and its usage. My friend and fellow MVP Jacob Sebastian is expert in XML, so if you are interested in XML please visit his blog here. If you are interested in performance optimization for XML Data type in SQL Server following article is must…

SQL SERVER – XML – Split a Delimited String – Generate a Delimited String

August 17, 2008

Pinal Dave

SQL Tips and Tricks

Best Practices, MVP, SQL Scripts, SQL Server, SQL Stored Procedure, SQL XML

SQL Server MVP and my very good friend Jacob Sebastian has written two wonderful articles about SQL Server and XML. I encourage to read this two articles to anybody who are interested in learning SQL and XML. Let us see how to Split a Delimited String.

SQL SERVER – Fix : Error : Msg 9514 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s)

June 9, 2007

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL XML

In this blog post we are going to learn how to fix XML Data Type related error.