Thanks for the article, Mike!
Just curious: Why have not you used WITH RECOMPILE option? I believe one has more flexibility with this option if specified in a procedure call statement. Alternatively a procedure can be created with this option.
And the join hints can tell SQL to use a particular join every time, just in case