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) RegardsI 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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Thanks for the links folks
]]>