UPDATE: I played around with this last night, it's amazing. If you use SQL, you need to try this out.

When I'm programming an application that utilizes a SQL database. I often spend quite a bit of time using SQL Query Analzyer. Inside the query tool, I also seem to experience amnesia. I often forget table names, the columns in my tables, sproc names, and don't even get me started on syntax. Eric Hulbert at opus:creative pointed me to SQL Intellisense at http://www.promptsql.com/

I'm going to install it and try it tonight, but this looks just like the Visual Studio IDE's implementation of intellisense. This thing is even smart enough to parse your SQL code as you go becoming aware of things that you have already typed. So you're writing a select staement joining several tables? Those joined tables become part of the intellisense, and they'll even suggest how to complete your joins. Amazing.

It's super cheap too, $25 for an individual license!

Check out this image of the tool in action: