All Questions
Tagged with parameter-sniffing table-valued-parameters
2 questions
0
votes
0
answers
388
views
Filter the data inside a stored procedure using Table-Value parameters
I have a stored procedure which receives multiple table-type parameters and I want to filter the data using those parameters. The problem with that is those parameters can contain no rows and in that ...
5
votes
2
answers
3k
views
Parameter sniffing on table valued parameters
I'm fairly certain that adding parameter sniffing to table valued parameters is of little or no value however I was wondering if someone could confirm this?
(INT_LIST is a user defined table type ...