SSMS Tip – Display Results in a Separate Tab

One of my co-workers pointed out a setting in SQL Server Management Studio that has been extremely useful to me.  It is the [Display Results in a Separate Tab] setting. This setting is helpful if you want to see more T-SQL code and/or more data in the return set. I am a fan of both.

To enable this setting go to Tools > Options…

Select Query Results > SQL Server > Results to Grid — and check Display results in a separate tab as well as Switch to results tab after the query executes

As you can see, when you execute a query, the results are displayed in their own tab.

I have found this setting helps a lot with really long stored procedures.  It is nice to be able to see more code at one time.

–

Until next time…