The main problem is that do a quick query you find something that you have to load the whole of Management studio...  It is feature rich - but very annoying to do the simpliest of things.

And as per usual the memory usage goes through the roof ... especially when you have VS open as well.. Can't Microsoft still provide us will a simple QA tool - When I upgraded all the old toll disappeared and have been unable to reinstall them.