Management Studio 2008- What I Like

There’s some pretty cool things about SSMS 2008– I am really pleased that execution plans open graphically by default now, and it’s easy to view the XML on demand. I had gotten pretty fast at saving things as .sqlplan, but it was a bit of a drag.

But my very favorite thing is really simple. I’m not sure if it even made it into the ‘feature lists’ anywhere. It’s this:

  • When you are running a query in a tab, the top of the tab has the note as ‘Executing’ until it completes.

Whomever got in this feature has my sincere and heartfelt thanks. This is incredibly useful to me. I frequently need to run manual commands to verify data to troubleshoot things that shouldn’t be automated, and it’s really nice to be able to move to another tab and periodically glance at the tab header to see when it completes. No more clicking back to  it, or running sp_who2 if I happen to be on the same server.

Previous Post
Profiler: Deadlock Graph Event
Next Post
Backups – Using SQL Agent Tokens to Set the Date, and Why to go MultiFile

Related Posts

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Menu