Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Table Design for storing xml message Expand / Collapse
Posted Thursday, September 10, 2009 10:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 15, 2009 3:53 AM
Points: 4, Visits: 18

I am desiging a table for logging xml messages, size of the row may grow more than 8kb (page size).
I am little worried about the Query, which will eat up the processing time, if the record size goes above the page size (8kb) and store it in ROW_OVERFLOW_DATA.

(Row-Overflow Data Exceeding 8 KB)

Table structure :
Message_Id Int
Message_Value varchar(max)

Can someone please help me on the Best practices for storing xml message into a SQL Table, what will be best data type can be used ? size of the xml message gets stored is not limited to the size (can be of size 2kb, 8kb, 10kb, 200kb etc...). Expecting your valuable response.

Note : I cannot use the xml datatype as we may get unstructured xml sometime, leads to parsing error while inserting the data.

Thanks in advance.


Post #785821
Posted Thursday, September 10, 2009 1:30 PM



Group: General Forum Members
Last Login: Wednesday, February 10, 2016 11:50 AM
Points: 6,897, Visits: 13,559
duplicate post.
discussion already started here

A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #785950
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse