• Skip to main content
  • Skip to primary sidebar

DallasDBAs.com

Explaining SQL Server in plain english

  • Services
    • SQL Server Health Check
  • Pocket DBA®
  • Blog
    • Speaking
  • Testimonials
  • Contact
  • About

SSMS – How to get two rows of tabs

August 26, 2022 by Kevin3NF 4 Comments

If you spend much time at all in SQL Server Management Studio (SSMS), you’ve no doubt had trouble figuring out which query tab is the one you need.

Many DBAs and SQL Devs find themselves (despite best intentions and New Years Resolutions) with dozens of tabs open, and many of them unsaved.

Thanks to Daniel Maenle (LI|T)’s comment on a LinkedIn post, I went digging and now my life is better!

Pin Important Queries

I have some saved queries I leave open all the time for various reasons. As an example:

When I open a few new queries, typically in a frenzied troubleshooting session, it looks like this:

Yours is different by default. Note the highlighted bits. My saved queries I always use are “pinned tabs”. The Second row is New Queries that I have not yet saved.

You can change this here, with immediate effect (Tools, Options):

Hope this helps you organize your SSMS and brings you a few minutes of sanity!

Thanks for reading!

Kevin3NF

Follow @Dallas_DBAs

 

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to email a link to a friend (Opens in new window)
  • Click to print (Opens in new window)

Related

Filed Under: Uncategorized

About Kevin3NF

Reader Interactions

Comments

  1. Cujo says

    August 27, 2022 at 7:15 pm

    Nice. I know just the usage.

    Reply
  2. Rob says

    January 12, 2023 at 7:13 pm

    Thanks, would be great to just allow 2 or more rows but this is a good compromise!

    Reply
    • Kevin3NF says

      January 13, 2023 at 9:42 am

      Agreed…but I’d take a lighter weight app and 64 bit first if I get to be picky 🙂

      Reply
  3. Curt Wolfe says

    March 30, 2023 at 11:42 am

    In my opinion, you should take this a step further. IN SSMS options, go to “Text Editor”, then “Editor tab and status bar”. Under “Tab Text” section, set “Include file name” to true, set others to false. Now you have shorter descriptions on tabs, and you can manage more tabs without the dropdown list of tabs.

    Thanks for the “Show pinned tabs…” tip!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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

Primary Sidebar

Search

Sign up for blogs, DBA availability and more!


Categories

  • Accidental DBA
  • Apprentice
  • Azure
  • backup
  • backup
  • Beginner
  • Career
  • Configuration
  • Cycling
  • Dallas DBAs
  • Deployment
  • Emergency
  • Encryption
  • EntryLevel
  • Fries
  • Goals
  • HADR
  • HealthCheck
  • Index
  • Install
  • IRL
  • Management
  • Migration
  • MySQL
  • Oracle
  • PASS
  • Performance
  • Personal
  • Pluralsight
  • Podcast
  • PowerShell
  • red gate
  • Restore
  • Security
  • Speaking
  • SQL
  • sql 2005 log shipping suspect
  • sql injection
  • SQLSaturday
  • SSIS
  • SSMS
  • Summit
  • TIL
  • Tools
  • Training
  • Troubleshooting
  • TSQL
  • TSQL2sday
  • Uncategorized
  • Upgrade
  • vendor code modify
  • video
  • vNext

Copyright © 2023 · Genesis Sample on Genesis Framework · WordPress · Log in

Privacy Policy
 

Loading Comments...