Troubleshooting Common XQuery and XML Problems in Microsoft SQL Server Based on Real-World Examples
Play Troubleshooting Common XQuery and XML Problems in Microsoft SQL Server Based on Real-World Examples
How often have you written an XQuery in SQL Server and your performance was so bad that you were able to eat lunch while the query executed? Have you ever wondered that you have specified secondary XML Indices and the query was not using them? Or have you ever wondered how to write your best XQuery so that SQL Server actually answers them (orders of magnitude faster) and you can get the answer in less than a second instead of minutes? In this session we answer some of the most common issues and mistakes and give you tips on how to improve your query performance.