I am using table-valued parameters stored procedure in SQL Server 2008/2012. In the past I had instance problems passing 50k rows (instance stop responding, memory issues) so now I limit the number of rows in tvp to 5-10k .
Is there a limit for the number of row to pass to table-valued parameters stored procedure in SQL Server 2012/2016? Is there a way to use tvp stored procedures passing >=100k in a safe way? Are there better way to work around this problem?
Thank you