Table valued parameters (TVP) are a great feature that solves the problem of passing a table of values into a stored procedure.  In the past problems like this would get solved by complicated approaches such as passing and parsing XML, or passing long streams of dynamically generated SQL.  There is a caveat you should be aware … Continue reading Table valued parameters and performance