I have a whole presentation with TSQL examples on temporary objects.

Coverage:

1 – Derived tables.

2 – Local temporary tables.

3 – Global temporary tables.

4 – Table variables.

5 – Common Table Expressions (CTE).

6 – User databases in [tempdb].

7 – Trace Flag 1118.

http://craftydba.com/?page_id=880

Enjoy ...