SQL Server Performance Forum – Threads Archive

XML vs. Relational

We are a software vender and we have been migrating our application from SQL 2000 relational to 2005 native xml format.
Our studies have shown that having our data in native XML format in SQL 2005 presents many benefits; however, we have not been able to fully verify the performance (transaction, query, update, insert, etc…) of native XML data in comparison to relational data in SQL 2005. Does anyone know of such a comparative study or possibly has suggestions on how to setup a such a test? any help would be greatly appreciated!

Kindly don’t duplicate posts. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>