Free SQL query analyzer w/IntelliSense
This is a pretty neat SQL Query Analyzer-like app that provides intellisense and datagrid (ie editable) results. Best of all, you don't need to install the SQL client tools on all of your machines! Also great if you develop against MSDE.
SQL Buddy [via Chris Sells]
 CTRL-Space. Check out Help for more info.