I have been writing a lot of T-SQL Scripts for SQL Server for a client to migrate to a new database schema. Whenever I get deeply involved in something like that I find that it is handy to create a cheatsheet for all of the things you have to lookup in the docs.
So here's my latest: Cheatsheet for SQL Server T-SQL, please let me know what you think.
By the way if you find cheat sheets handy you might want to checkout my cheatsheet roundup for developers which lists tons of handy cheatsheets for web developers.