(Posted this in Database Design, but then thought I should post here as well)
I am trying to figure out what would be the best method for storing xml documents in the db...if we should use an XML type field or if we should use the newly introduced FILESTREAM? We would have a need to shred those documents for queries and possibly
use the FULL TEXT SEARCH to allow for user defined searches on those documents. Does anyone have any thoughts on either approach for SQL server 2008?
Always apprecaite the input I get on this forum...very helpful.
View Complete Post