Hello,

Thanks for your post. It is really useful.

Currently I am facing an issue related to performace if XML is huge (nearly about 1 MB in size - 200 records). I am using SQL Server 2008.

Our application is executing the stored procedure by passing XML as a input parameter. XML contains namespaces so I am using "WITH XMLNAMESPACES" command and use "FROM nodes" method - "T.C.value" to retrieve the information from XML file. I am parsing it and return the result set.

Can you please guide me how can I improve the performance as well as steps needs to be taken to improve the performace?

Thanks, Hardik