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
  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.
  3. satya Moderator

  4. tmarko New Member

    Thanks for the links folks

Share This Page