A poorly written query can code trouble if the SQL server cannot predict a good execution plan because of too many type conversation and varchar max parameters:
After changing the code
Dynamically generated code T-SQL code can cause trouble
Month: January 2023