I am storing xml in a table, which is used later to reload an app. I figure fastest loading and retrieving would be to just store full xml text into a text or ntext column. So two questions, and pros or cons with text vs. ntext? Also, would it be better to parse out the xml for some reason, and store in database in a broken out 'relational' way, then rebuild xml later? Doesn't seem like it would be, but not sure if I'm missing something
Thanks!