My boss is a professional. He was a developer recently.

I saw some of his stored procedures - good code.

I think he has a point. A few years ago at one large bank

production support team had big problems debugging complex long stored procedures

with lots of dynamic SQL. Production Support Team Lead just begged us to avoid using too much dynamic SQL.

Some people argue that for dynamic SQL, SQL Server engine cannot build optimized execution plan.

Not sure who's right who's wrong.