SQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005

I always wanted to learn XML and its usage. My friend and fellow MVP Jacob Sebastian is expert in XML, so if you are interested in XML please visit his blog here. If you are interested in performance optimization for XML Data type in SQL Server following article is must read for you.

Performance Optimizations for the XML Data Type in SQL Server 2005 by  Shankar Pal, Babu Krishnaswamy, Vasili Zolotov, and Leo Giakoumakis – Microsoft Corporation

Articles covers following subjects.

  • Introduction
  • Data Modeling with the XML Data Type
  • Bulk Loading XML Data
  • Indexing XML Data
  • Query and Data Modification
  • Conclusion

You can download the same article in word format from here.

Reference : Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
SQL SERVER – Start SQL Server Instance in Single User Mode
Next Post
SQL SERVER – Simple Example of Creating XML File Using T-SQL

Related Posts

1 Comment. Leave new

  • Hi Sir,

    Please help me to provide a script with blocking details , including blocking query.

    Reply

Leave a Reply

Menu