Microsoft SQL Server 2005 introduces a new data type called XML for storing and manipulating XML data at the server. This webcast looks at techniques for optimizing applications using XML data type by first examining the XML index mechanism and then showing how to design and use XML schemas in query optimization, property promotion, and writing efficient path expressions. Also, learn how to troubleshoot XML applications by analyzing semantic correctness of queries, monitoring performance, usi...

Read more