XML Handling in Microsoft SQL Server 2005

Friday Oct 19th 2007 by DatabaseJournal.com Staff

Ivan Pepelnjak describes how to use the XML data type introduced in Microsoft SQL Server 2005 to increase the speed of your SQL queries and updates.

[From InformIT]

If you have to store loosely structured data (or data in which the structure is expected to change significantly in the future) in a relational database, it might be best to store the less rigid part of the data in XML format, using the traditional table columns to store just that part of the data that’s well-defined, refers to other tables, or participates extensively in database queries.

The article continues at http://www.informit.com/articles/article.aspx?p=1021368&rl=1

Mobile Site | Full Site