TSQL Tips on Performance

I was researching some query performance tips and came across a great article by Grant Fritchey called "The Seven Sins against TSQL Performance". I would strongly recommend reading over the article. I have outlined a few things that caught my attention.

• Functions in Comparisons within the ON or WHERE Clause
• Employing Multi-Statement User Defined Functions (UDFs)
• Applying Query Hints indiscriminately
• Indulging in Nested Views

Reference Link: