Post reply

Table Design for storing xml message

  • September 10, 2009 at 10:09 am

    #385342

    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

  • September 10, 2009 at 1:30 pm

    #1051922

    duplicate post.

    discussion already started here


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply