XML and SQL server 2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

XML and SQL server 2000

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

I personally would never store XML inside SQL Server 2000. Are you talking about 2005 by any chance? Big difference here. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks for the links folks