Loading user information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading user information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Deep Dive into XQuery and XML in Microsoft SQL Server: Common Problems and Best Practice Solutions

1 hour, 17 minutes, 10 seconds


Right click “Save as…”

Slides (view online)
Have you ever written an XQuery against the XML data type and had performance issues? Have you ever wondered how to improve performance of your XML-based application? In this presentation, we analyze commonly encountered query patterns and performance issues and provide best practices and improved queries that can improve performance up to an order of magnitude. We provide guidance on how to best store XML inside the database (relational vs. as XML datatype, with or without a schema, which XML Index should I use?) and provide performance tips when using XQueries and FOR XML queries. In addition, we give a quick preview of a new XML Indexing option that we have been developing for one of our premier banking ISVs which will be productized in a future release. #TEDBI404
For more information, check out this course on Microsoft Virtual Academy:

Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation

Remove this comment

Remove this thread


Comments closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.