it's also important to note that temp tables are a sign of ineffective design and workarounds (usually performance related). In an ideally designed database (sitting on an ideally designed db server) there would be absolutely no need for temporary tables.

Don't get me wrong; I use them when I have to, but I don't like them. Kind of like cursors.