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

  • 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