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.
SQL Server 2005 - XML and XML Query Plans
Filed in
- Organiser
- Scottish Developers
- Date
- Wed, 6 Jun 2007, 19:00 - 21:00 (Add to calendar) GMT
- Venue
- Glasgow Caledonian University , Glasgow, GB
- Cost
- Free
You might also like...
Other nearby events
Map
SQL forum discussion
-
problem with select within select
by hamidreza.hr923 (2 replies)
-
convert EMPTY fields to NULL?
by viktorcheberachko (5 replies)
-
how to delete values of a particular column in a table
by sanjaymishra112sm112 (7 replies)
-
XBrowse
by liuying9104 (3 replies)
-
generating xml file
by huangdm05941 (2 replies)
SQL podcasts
-
Deep Fried Bytes: What is the Big Deal about Big Data?
Published 8 years ago, running time 0h39m
In this episode, Woody sits down with Andrew Brust to discuss another “big” technology for developers and IT professionals: Big Data. Woody and Andrew talk about what Big Data is, who is using it, what tools are available and finally how we has technologists can use this for our products and serv.
Comments