Controlling what appears on your tabs
You can control what appears on your tabs from SQL 2008 onwards. Its still not ideal, IMHO you need to have multi line tabs to show server, database, filename etc.
Anyway to control what appears go to Tools | Options and then select the Tec Editor node and the Editor Tab and Status Bar sub node
This will look something like this.
You can’t change the order or how the text gets shrunk if its too long but you do have some control.
When you edit the rows in the table, the table name appears like the filename.