A good set of tips. The first focuses on using SET and DBCC, the second focuses on Indexing strategies, and the third focuses on Query optimization: