XML Data Type

Last Post 14 Nov 2008 06:35 AM by Worldnow1. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Worldnow1
New Member
New Member

--
13 Nov 2008 09:13 AM
Hey All,

I will be storing some XML in my database strictly for storage and retrieval purposes. I know that with SQL 2005 is powerful XML support and that this column can be indexed. If I do not plan on changing the XML itself would it be better to store the data as nvarchar(max)? Again I am just looking for the quickest way to search the XML once it is stored. Thanks in advance for all your help and guidance.

Paul
SwePeso
New Member
New Member

--
14 Nov 2008 02:05 AM
The fastest way to query the data is to denormalize the XML data into a table.
If this is not an option, create an xml index on xml column.
Worldnow1
New Member
New Member

--
14 Nov 2008 06:35 AM
I apologize for my ignorance, but how would i go about denormalizing the xml into a table?

Thanks again for your help...


Acceptable Use Policy
---