T-SQL performance problems and solutions

Recently I came across a great article about T-SQL performance. Baya Pavliashvili explains subjects like cursors, stored procedures vs. inline queries, views, record blocking, and much more... Read the article here: http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1170220,00.html