XML Handling in Microsoft SQL Server 2005

October 19, 2007

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