This is a follow up of my earlier blog which got instant popular Split Screen for SSMS Efficiency – SQL in Sixty Seconds #120. Lots of people asked me to share the SSMS efficiency tip so I have shared the same in this blog post. Today’s topic is the pinned tab in SSMS for efficiency. I use this tip very frequently with my clients during the Comprehensive Database Performance Health Check.
Let us assume that you have been working for hours on SSMS and there are so many different tabs you have open. Now it is quite possible that one or two of the tabs in your SSMS are very important tabs for you as those are the tabs that you need to frequent to work on the other tabs. Often people spend up to minutes of the time to relocate their important tabs in SSMS.
The solution for this one is pretty simple if you use the pinned tab. I have explained the same in this very short SQL in the Sixty Seconds.
Here are a few associated blog posts which you may find interesting.
- Activity Monitor and Running Query – SQL in Sixty Seconds #115
- Email an Execution Plan – SQL in Sixty Seconds #114
- Execution Plan – Estimated vs Actual – SQL in Sixty Seconds #113
- What Happens If the Clustered Index is Disabled? – Interview Question of the Week #291
- Nonclustered Primary Key – SQL in Sixty Seconds #119
- When was Stored Procedure Last Compiled? – Interview Question of the Week #292
- Recent Execution of Stored Procedure – SQL in Sixty Seconds #118
- Full-Screen Execution Plan – SQL in Sixty Seconds #117
- Recover Crashed Query in SSMS – SQL in Sixty Seconds #116
If you like the video, please do not forget to subscribe to my youtube channel. Let me know if you have any other SSMS tip which you think help the larger community.
Reference: Pinal Dave (https://blog.sqlauthority.com)