Feeds:
Posts
Comments

Posts Tagged ‘SQL XML’

SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology, tagged , on July 3, 2010 | 7 Comments »

Earlier I wrote a blog post on SQL SERVER – Parallelism – Row per Processor – Row per Thread, where I mentioned the XML Plan. As a follow up on the blog post, I received the request to send the same execution plan so that the blog readers can also use the same and reproduce [...]

Read Full Post »

SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on June 23, 2010 | 9 Comments »

One of the most common problem SQL Server developers face while dealing with XML is related to writing the correct XPath expression to read a specific value from an XML document. I usually get a lot of questions by email, on my blog or in the forums which looks like the following: “I have the [...]

Read Full Post »

SQLAuthority News – Converting a Delimited String of Values into Columns

Posted in Pinal Dave, SQL, SQL Authority, SQL Function, SQL Query, SQL Server, SQL String, SQL Tips and Tricks, SQLAuthority Website Review, T SQL, Technology, tagged on February 10, 2010 | 2 Comments »

This blog post is about two great bloggers and their excellent series of blog posts. It was quite unusual to see two bloggers posting articles that are supporting each other and constantly improving the articles to the next level. Two blogs which I am going to mention here are as follows: SELECT Blog FROM Brad.Schulz [...]

Read Full Post »

SQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL String, SQL Tips and Tricks, T SQL, Technology, tagged on December 21, 2009 | 10 Comments »

In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that was discussed on show was [...]

Read Full Post »

SQL SERVER – Validate an XML document in TSQL using XSD by Jacob Sebastian

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on December 2, 2009 | 9 Comments »

Following article is sent by SQL Server MVP Jacob Sebastian on request to provide solution for validating XML document. XML Schema Collections Because of the ‘eXtensible’ nature of XML (eXtensible Markup Language), often there is a requirement to restrict and validate the content of an XML document to a pre-defined structure and values. XSD (XML [...]

Read Full Post »

Older Posts »