dbForge SQL Complete

I found a very good free tool for SQL Management studio; it will make your life typing t-sql much easer.
Download link: http://ping.fm/dswd7
Select the express edition it’s free.

Note: if you installed Visual Studio SP1 on your computer and you had MS SQL Management studio 2008 R2, Intelsense will stop working, there is a very large fix from Microsoft to fix it, but this solution is much better in my eyes