One of the most annoying things of SSMS is that the SQL query tabs are too big, this because it includes Filename + Server + Login User, and I really don’t see the point for that, because you can only visualize 3 or 4 tabs at a time before it starts to collapse the rest, see example:
Fortunately there is away to make the SQL query tabs smaller so you can see more at a time, and here is how:
On your SQL Server Management Studio, Go to Tools -> Options.
Expand “Text Editor” and Select “Editor Tab and Status Bar”
On “Tab Text” set all to false except for filename:
Now see the difference: