SQL Server Performance

XML vs. Relational

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by harout, Dec 14, 2005.

  1. harout New Member

    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!
    harout, Dec 14, 2005
    #2

  2. Luis Martin Moderator

    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.



    Luis Martin, Dec 14, 2005
    #2

Share This Page