Easy way to analyse results
I have seen in many video tutorials they have different tabs for Editor, Results, Messages and Execution Plans. And they are stretched over the complete screen. Most of the times need to resize the result area to see our results. Actually, it's annoying me. Then I noticed in one of Paul Randal’s video he uses Separate tabs for Results editor and messages in SQL Server Management Studio (SSMS). Then I wanted to find how to get those tabs to my SSMS (Often I call it SMSS don’t know why ).
1. Open you SQL Server Management Studio (SSMS)2. Go to Tools –> Option3. Check “Display results in a separate tab” and “Switch to results tab after the query executes” both.
4. Click ok and enjoy Results like this.
If you don’t like to use it always you can use this option to a single script by click on Query option on the toolbar and follow 3rd step.