TomThomson (10/23/2014)
...I agree that XML doesn't always provide an answer (in my experience a decision to use XML has more often been part of the problem than part of the solution).
Often it is misused as a way to avoid converting XML documents/fragments. Or stipulated as a requirement by someone who is not an implementer (i.e. neither a coder nor a DBA) or, wholly unforgivably, a lazy coder.
If data needs to be processed by a RDBMS then it needs to be stored as relational data. Storing XML in an RDBMS, for me, is the equivalent of storing media files e.g. I would not use SQL Server to sharpen an image file.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!