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 :
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.