I can’t be the only one to notice that the Tabbed Window Management in MS SQL Server Management Studio (SSMS) is just plain awful.
As my day, or task, or project progresses, I end up with more and more windows open. The order of those tabs is useful information to me, as it keeps track of the progression of the work I am doing. But, depending upon the size of your screen, as more tabs are opened, tabs start to get bumped off the tab bar into some kind of limbo where they are only available on the dropdown list at the right.
You cannot just scroll the tabs left and right to find your tab. Once they drop off into the pulldown, they are also no longer displayed in the order that they were on the tab bar. So when I’m looking for a window, I have to actually KNOW what meaningless tab name I’m looking for. Otherwise, I end up pulling the dropdown down numerous times and poking around until I find the one that actually is my “ALTER TABLE”, or “CREATE PROCECURE” or whatever.
The problem is one or more of them are Stored Procedures that I am modifying, others are ad hoc queries I am working on, one of them might be a TABLE I am altering. But ALL of them say the same thing: SQLQueryN.sql.
Complicating this is the fact that the text of the tabs is virtually meaningless. In my example above, all I see is SQLQuery1….prod.sql, SQLQuery2…prod.SQL……. SQLQuery6…prod.sql. etc etc etc. And things don’t get any better once they drop off into the dropdown where, presumably, you can take as much width as necessary to display the full tab name. But they don’t. The dropdown window name displays the same abbreviated, chopped, and useless information as it did when it was on the tab bar.
All in all, I’d REALLY be happy if MS came up with a different way of handling this.
In the mean time, you can open Tools –> Options –> “Editor Tab and Status bar”, and choose which useless information you want on your tabs.
But it’s still a kludge.