Recommended plugin for SQL server 2008
SentryOne Plan Explorer (free) - analyze execution plans in a way you could never do with Management Studio alone (I also wrote a demo kit here)
SSMS Tools Pack (free) - lots of valuable features here - snippets, connection color coding that works, CRUD generation, and query execution history