I hate the way SSMS tabs look by default. Check this out:
That’s nearly useless. The tabs are wide, but they still don’t show useful information. Even worse, I’ve got more tabs than I can fit in the window, so the rest hang out in a meaningless dropdown.
To fix it, click Tools, Options,and go into Text Editor, Editor Tab and Status Bar. Check out the Tab Text options:
You can uncheck the database name, login name, and server name because those are shown in the status bar anyway. Then, if you wanna get fancy, change the status bar location to Top – it’s right above the Tab Text options. Voila:
When I’m working, I save my queries in c:\temp with a short descriptive name. If I’m performance tuning, I’ll save them as Before.sql and After.sql, or maybe Index1.sql and Index2.sql. Presto, I can easily switch tabs without playing the guessing game.