Table Design for storing xml message

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Table Design for storing xml message

Table Design for storing xml message

Rate Topic

Display Mode

Topic Options

Author

Message

hariharan_marudan

Posted Thursday, September 10, 2009 10:09 AM

Forum 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

LutzM

Posted Thursday, September 10, 2009 1:30 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 3:17 PM
Points: 6,731, Visits: 12,131

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 »

Permissions