Display Results in a Separate Tab in SSMS Query Editor

By default, the query and query results in SQL Server Management Studio (SSMS) are displayed in the same query editor tab:

query_and_results_same_tab

Query results can be set to open in a separate tab together with messages and execution plans.

Click Tools -> Options

In Options window choose Query Results -> SQL Server -> Results to Grid or Results to Text
Check "Display results in a separate tab"
You can also check "Switch to results tab after the query executes"
Click OK

Results to Grid:
query_and_results_separate_tab_grid

Results to Text:
query_and_results_separate_tab_text

Open new Query editor window to use this settings:

query_and_results_separate_tab