the table valued parameter is good unless they cross 1000 rows but what if i increase columns.

Question

https://learn.microsoft.com/en-us/sql/relational-databases/tables/use-table-valued-parameters-database-engine?view=sql-server-ver15

in above link , i found
"table-valued parameters perform well for inserting less than 1000 rows."

the question is if i add more cols up to 60 to 100 will there be any problem, because artical does not say any thing
about columns.

and i feel that inserting more cols might do the damage as far as the performace is concerned.

Answer 1

I am sure that I am guilty of having sent more than 1000 rows to a TVP.

But I guess the gist of what they are saying is that the more rows you will be inserting at a time, BULK INSERT or the SqlBulkCopy class will be better choices for performance.

Answer 2

Hi @rajesh yadav ,

Quote from the blog, the results are as follows, with the fastest time highlighted in green and the slowest time highlighted in red for each data volume. (Note that all times are in milliseconds.)

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.