SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen

I had a great, unforgettable time at Teched India 2009 in Hyderabad. I had delivered a successful session on SQL Server Management Studio Best Practices, which created a lot of interest in community. I was truly amazed at the tremendous response I got. I received countless different questions on this subject as soon as the event was over. One of the most frequently asked questions was about my demo on how to increase real estate of SSMS (SQL Server Management Studio).

I had explained the following two different methods:

1) Open Results in Separate Tab

This is a very interesting method as result pan shows up in a different tab instead of the splitting screen horizontally.

To enable this, first go to Tools >> Options >> Query Results >> Result to Grid (or Text) >> Enable Display results in a separate tab.

SQL SERVER - Maximizing View of SQL Server Management Studio - Full Screen - New Screen newtab

SQL SERVER - Maximizing View of SQL Server Management Studio - Full Screen - New Screen newtab1

SQL SERVER - Maximizing View of SQL Server Management Studio - Full Screen - New Screen newtab2

SQL SERVER - Maximizing View of SQL Server Management Studio - Full Screen - New Screen newtab3

If you want to switch to a result set after the results are generated enable additional check box of ‘Switch to results tab after the query executes’. I do not find this option comfortable, as while working on query my focus on the working windows suddenly shifts to new windows.

2) Open SSMS in Full Screen

This works always and to its best. Not many people are aware of this method; hence, very few people use it to enhance performance.

SQL SERVER - Maximizing View of SQL Server Management Studio - Full Screen - New Screen newtab4

Press Shift + Alter + Enter to enable full screen on computer.

SQL SERVER - Maximizing View of SQL Server Management Studio - Full Screen - New Screen newtab5

In my opinion, by using the above both the options running together one can certainly increase more work area on computer screen. Are you using any of these options? Please share me with by leaving your comments here.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Puzzle – Write Script to Generate Primary Key and Foreign Key
Next Post
SQLAuthority News – Download – Cumulative Update Package for SQL Server 2008

Related Posts

6 Comments. Leave new

  • Thanks for pointing these good options. Both options are quite handy and useful. I would like to know if there is some hot key to switch between editor and result tabs. It would allow to work independent of mouse in this case.

    Regards

    Reply
  • Very nice explanation of both option.
    You are right sir both option together we can increase the
    work area and one of the important thing you can concentrate on one thing that is very important to work in Sqlserver.

    Reply
  • Pinal any palns to visit Teched-09 DownUnder??

    Reply
  • Marek Śliwiński
    July 27, 2009 6:07 pm

    thx!

    Reply
  • How do you view the full sql file that created the database?

    Reply

Leave a Reply

Menu