In this presentation Martin Bell, will be looking at the different ways to create XML query plans such as T-SQL statements, SQL Profiler and DMVs. He will look at using XML schemas and the schema used for XML Query Plans. Methods of loading XML Query Plans into a database including SSIS, CLR and T-SQL statements will be demonstrated. XML Query Plans with be analysed using XQueries to show how you can monitor and detect performance issues.
Martin Bell has been a freelance computer consultant in the
UK for over 23 years. He has worked on many relational database systems and since the 1998 has specialized in SQL Server. He was first awarded Microsoft MVP (SQL Server) status in June 2003.
This event is run by Scottish Developers in conjunction with the Scottish SQL Server User Group.
Official Website: http://www.scottishdevelopers.com/modules/extcal/event.php?event=33
Added by ColinAngusMackay on April 21, 2007