If I'm not wrong, the way sp_executesql is being used in this article is not the right one when we think about a better plan cache use.

Something like the following...