Re: SQL2005: shred the feeds or store as XML?

Another "rule" is whether you often repurpose part of the data in different
ways (shred it) or you mainly retrieve the full XML document (keep it
whole). And then you may as well promote properties or define indices for
faster access...

Best regards
Michael

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%23Mpoy7dBGHA.2568@xxxxxxxxxxxxxxxxxxxxxxx
>I think the "rule" is that if you need to update the data frequently you
>get better performance if you shred it. Otherwise store it as XML in the
>XML data type.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "clintonG" <csgallagher@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:ORLQ%23BcBGHA.3840@xxxxxxxxxxxxxxxxxxxxxxx
>>I hope I can get some insight into this issue. I'm developing a feed
>>builder and intend to host feed data to make it available for search and
>>analytics and so on. What's my best strategy? Shred the feeds or use
>>SQL2005 to store the whole file as XML? Any white papers or other
>>documents about this specific concern?
>>
>> <%= Clinton Gallagher
>>
>
>


.

Relevant Pages

  • Re: SQL2005: shred the feeds or store as XML?
    ... Otherwise store it as XML in the XML ... >I hope I can get some insight into this issue. ... Shred the feeds or use ...
    (microsoft.public.sqlserver.xml)
  • Re: Wanted:MAIL.MAI structure definition
    ... exports using XML. ... SMTP mail and all the software out there which processes RFC-compliant headers ... I would maintain that to store mail messages you would need to use CLOB ... Every mail message arriving into an OpenVMS system gets its format converted. ...
    (comp.os.vms)
  • Re: ruby / rexml / xpath bug?
    ... puts of the XML. ... end # end each store ... Longitude: -74.107299 ...
    (comp.lang.ruby)
  • RE: Embedd XML within XML - Possible ??
    ... it is not quite recommended that we store such ... If you do want to store complex XML data into the attribute field. ... Microsoft MSDN Online Support Lead ... ID Field and String Field ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Why choose SQL Express over Access?
    ... I am thinking of coding a data store that many store locations will use to ... get national sales averages. ... Each location sends in its data in in XML ... Ability to do asynch apps ...
    (microsoft.public.dotnet.framework.adonet)