SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Cleaner Code Demos – Speaker Hints

Recently I had the privilege of watching Paul Randal and Kimberly Tripp present (separately) at SQL Server Connections. If you have never seen them talk I would highly recommend you make time if you are ever at an event with them. They do a fantastic job.

In any case, they used SSMS quite regularly to show how various things worked in SQL Server. The thing that struck my quite quickly was the easy in which I could see what they were doing, and they could also track where they were in a large complex script.

Typically when I see someone using Management Studio to present it looks like this:


Granted, this is small, but when it’s projected on a screen, it’s not likely to be much better. The important stuff, the query, and the results, are actually a little hard to see.

When I watched Kimberly do this, I saw this for the query:


With this appearing after execution


A couple things to notice here. First, under the main tab, in this case for SQLQuery1.sql, there are two sub tabs. One is the editor, so you can see lots of code (at font size 12). The other is the results, and when I execute a query, SSMS automatically switches to the results tab.

However not only do I have results, but I also have the query at the top. That easily lets me determine what I’ve just run. When you’re doing a few things, either on stage or at work, having the query shown is very, very handy.

How To Set This Up

First, auto hide the Object Explorer and save yourself some space. You can get the menu below by clicking the little triangle in the Object Explorer header bar.


First let’s set up results. I would change the results to text by right clicking in the query window:


Next, you want to go to the Query menu, and select the Query Options item. In this dialog, there are a few things to configure. First is the results item. Choose text and check the these three items:

  • Include the query in the result set
  • Display Results in a Separate Tab
  • Switch to results tab after the query executes


Then you want to up the font so things are easier to read. I do this first in the Text Editor (see the drop down at the top)


Then do this for the text results, changing the drop down again.


Now when you run a query, you’ll automatically switch over to a screen that is easier to read on a projector. And you’ll see the query you just ran, so it’s easier to keep track of where you are in your presentation.

I actually like these settings so much, I use them for any work I do in SSMS.

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


Posted by ThomasLL on 17 November 2010

I tried this in the last week to practice before tonights SSUG in Baton Rouge. I works well, except when you are using SET commands of DBCC commands.

If your script is long, many executable items, you are constantly switching back and forth. This might throw the attendees off.

I am going to try it tonight and see what happens.


Leave a Comment

Please register or log in to leave a comment.