While there are a great many books, blogs, and articles out there on T-SQL, there are always a few little "tricks" that many people overlook, or that many authors assume readers know.

WHILE Loops Speaking of those WHILE loops and cursors: Many people find themselves writing cursors when they need to iterate through a query.