SQL Server Performance

XML and SQL server 2000

Discussion in 'T-SQL Performance Tuning for Developers' started by tmarko, Dec 19, 2004.

  1. tmarko New Member

    Anyone who can give good advise in using XML in a SQL server 2000 dB. Microsoft is pumping out there mantra about XML. But is it at all so good to store everything in XML in the dB?

    If I want to make calculations in Store Procedures with dynamic SQL isn't it a overhead storing data in XML?

    I would like a more balanced picture of the XML story. Advantages and disadvantages.

    Anyone with experince or good articles (not Microsoft)

    Regards
    tmarko, Dec 19, 2004
    #2

  2. derrickleggett New Member

    I personally would never store XML inside SQL Server 2000. Are you talking about 2005 by any chance? Big difference here.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
    derrickleggett, Dec 19, 2004
    #2

  3. satya Moderator

    These 2 links will have information :
    http://www.sql-server-performance.com/sql_server_xml_distilled_chapter1_excerpt.asp &http://www.sql-server-performance.com/sql_server_xml_distilled_chapter1_excerpt2.asp and this MSDNhttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/html/TheXMLFiles.asp for preview information on XML.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Dec 20, 2004
    #2

  4. tmarko New Member

    Thanks for the links folks
    tmarko, Dec 20, 2004
    #2

Share This Page