Hi
I am declaring an SqlXml param and passing it a XmlReader. This then gets parametrized and the SQL gets executed all very well. However, when looking at the SQL which gets executed through profiler I notice that it is taking the SqlXml parameter and calling CONVERT on it...
CONVERT (xml, )
Why does the server need to call CONVERT, I've already passed it valid xml? Is it because I'm not defining a schema?
I suspect this is causing bad performance on this query. Any help would be fantastic.
Cheers