Discussion on answer by Brent Ozar: SQL Server Error 8632 due to over 100,000 entries in WHERE clause

@Dominique bad news: there is no quick fix for that.

@MguerraTorres Also, meta.stackexchange.com/a/12427/216712 "Reputation was never designed (and never could be) to indicate skill-level. It's simple a general indicater of how much useful input they have had around the site." Reputation is not a determiner of whether someone is right or wrong in any particular instance.

@MguerraTorres You would still have to deploy the proc change. Either way you're deploying something. Procs aren't magic :). Not much difference in deploying what should be a DLL vs a proc to a production system. Both would need to go through the same level of testing and rigger. I'd even argue replacing a DLL is easier.