Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

104


Part I: Laying the Foundations


Alternatively, the results can display in another tab, instead of at the bottom of the query
document. In Tools ➪ Options, use the Query Results ➪ SQL Server ➪ Results to Grid tab,
or in the context menu in the query window select the Results tab, and choose the Display
Results in a Separate Tab option.

Another useful Result option is to play the Windows default beep sound fi le when a query
completes. This can be set only in the Tools ➪ Options ➪ Query Results tab.

SQL Server 2000’s Query Editor had a toolbar button to open or close the result pane. It
disappeared with SQL Server 2005, but Ctrl+R still toggles the Query Editor Results Pane.
And the command is still in the Customize Toolbar dialog, so you can fi x the toolbar if
you want. It’s called the Show Results Pane, and it’s not in the Query category where you’d
expect to fi nd it, but hiding in the Window category.

Viewing Query Execution Plans
One of Query Editor’s most signifi cant features is its capability to graphically view query
execution plans (see Figure 5-11).

FIGURE 5-11
Query Editor’s capability to graphically display the execution plan of a query is perhaps its
most useful feature.

c05 July 23, 2012 11:44 AM V1


c05.indd 104c05.indd 104 7/30/2012 4:14:51 PM7/30/2012 4:14:51 PM


http://www.it-ebooks.info
Free download pdf