Pinned tabs in SQL Server Management Studio (SSMS)

Introduction

While working in SQL Server Management Studio (SSMS), we may need to open many query windows. But each time we may feel difficult to recognize the important query window which we need to refer frequently. There is an option, we can Pin the tabs which are mostly frequently referred.

Pinning Tabs

We can pin the query windows. At the top of the each query window, there is an icon to pin the tab, and once the tab in pinned it will always present in the left side of the SSMS, as shown below.

Fig 1. Pin Icon in Query Window
Fig 2. Once Pinned it will be at the left side in SSMS

There is another option to highlight the pinned tab as well. Just above we saw that the pinned tabs will be in the same row, in other option, we can keep the pinned tabs in separate row. To keep it in separate row, go to the Tools -> Options, select the Tabs and Windows option. Then tick the “Show pinned tabs in a separate row” checkbox, as shown in the below window.

Fig 3. Tool window to Separate the Pinned Tabs

Once the above settings is done, if we pin the query window, those tabs will be separated to another row as shown below,

Fig 4. Separate row for the Pinned Tabs

Conclusion

In this article, I have shared how we can pin our frequently required query window. Hope this tip was very useful. Please share your feedback in the comment section.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

WordPress.com.

Up ↑

%d bloggers like this: