Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Table Design for storing xml message Expand / Collapse
Author
Message
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
Hi,

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)
http://msdn.microsoft.com/en-us/library/ms186981.aspx

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.

regards

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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:15 PM
Points: 6,842, Visits: 13,370
duplicate post.
discussion already started here




Lutz
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