I've seen a lot of people rave about Red-Gate's SQL tools in the past. They provide a really nice set of tools that are well worth spending sometime to check out.
They have a promotional offer available now where you can download their new SQL Prompt Intellisense tool for free until September 1st (note: it does not timebomb after that date -- so you can use it forever). This tools provides intellisense completion for writing SQL queries and looks very useful:
You can learn more about it and download it for free here.
Hope this helps,
Scott