How to Display Query and Results in Separate Tab in SQL Server Management Studio (SSMS) - SQL Server / TSQL Tutorial Part 15

Scenario:

Every time I run query in SQL Server Management Studio (SSMS), the results are shown under the query window. To see the full result window, I have to drag up. Can I see the Query and Results in separate Tabs in SSMS?

Solution:

To see the Result Windows in separate tab, you will be going to Options as shown below.

How to see results in separate tab in SSMS - SQL Server Tutorial

Go to Query Results, Then SQL Server and then Results to Grid and check the Check Box

Display results in separate Tab

and Switch to results tab after the query executes

How to see results in separate tab in SQL Server Management Studio - SQL Server Tutorial

Now If you open a new query window and execute TSQL query, you will see the results window as separate tab as shown below.

How to see results in separate Tab in SSMS - SQL Server Tutorial Step by Step

I noticed one thing, If you right click on table and choose Select top 100 rows , you will see the query and results as you normal do in SSMS. It will not show the results in separate Tab. To do that you have to open new query and paste your query and execute.