Home Forums Programming XML Passing bulk data through xml parameter or table parameter in stored procedure, which one is better RE: Passing bulk data through xml parameter or table parameter in stored procedure, which one is better
Arthur Olcot
SSCertifiable
Points: 6546
More actions
December 12, 2013 at 4:56 am
#1672894
If you are able to influence the development from the off, then I would go with TVP as shreding XML is very expensive.
There are lots of resources on this very topic:
http://www.dbdelta.com/maximizing-performance-with-table-valued-parameters/
http://www.sommarskog.se/arrays-in-sql.html