To start with. I did not carefully read the entire article.
I stopped at the 5th time I saw "Select *" used in the code for an article about Query performance.
At that point I rolled through and it seems all the SQL uses "Select *" instead of selecting from column names.
You want to remove the Schema Scan that needs a shared lock to complete and will occur on every execution of your Performance tuned select.
This was an article about performance tuning right? 😉