This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

For XML vs OPENXML

Question
0

Sign in to vote

Which one of these are faster? I was told one of them takes 1/8th of the memory.

Thursday, July 16, 2015 5:19 PM

Answers

1

Sign in to vote
It depends on what do you want to do. Jacob Sebastian has a very good blog about XML and also I believe there was a quiz by him

Here is a link with a summary to all his XML labs:

http://beyondrelational.com/modules/2/blogs/28/posts/10279/xquery-labs-a-collection-of-xquery-sample-scripts.aspx

And this is the quiz on the topic of your question with answers:

http://beyondrelational.com/quiz/sqlserver/general/2010/questions/5/sqlserver-quiz-general-2010-jacob-sebastian-openxml-or-xquery-when-and-why.aspx
For every expert, there is an equal and opposite expert. - Becker's Law

My blog

My TechNet articles
- Proposed as answer by Eric__Zhang Sunday, July 19, 2015 12:02 PM
- Marked as answer by Eric__Zhang Friday, July 24, 2015 1:36 AM
Thursday, July 16, 2015 5:44 PM