Is there any difference between xquery and xpath performance in SQL Server 2008?
I'm very new to XML sql data type, and I would like to store document details as XML in SQL Server 2008 while performance of queries on this field is very important.
Do you have any experience of performance differences between xquery and xpath?
For my experience, OpenXML function is the best solution for xml parsing in SQL server, especially for huge data volume. Please refer this link. http://msdn.microsoft.com/en-us/library/ms186918.aspx