Wayne Sheffield

My blog about SQL Server

SSMS provides an Activity Monitor, a process that displays various information about what all is going on with the instance. This is available by right-clicking on the server and selecting Activity Monitor, or by selecting the toolbar icon for it. Either of these options will bring up the Activity Monitor in a new tab. In […]

SSMS has a lot of reports available for you to use. Most of the reports in SSMS are off of either the server node, or the database nodes. Simply right-click the node, and select reports. The server level reports are: And the database level reports are: Each of these reports provide useful, timely information. Once […]

If you are presenting with SSMS, then there are some extra steps that you need to take. These steps are all for the purpose of ensuring that everyone (especially those in the back of the room) can clearly see your demo in SSMS. The fonts used in SSMS and a few other settings need adjusted. […]

Over the last several weeks, we have been making several changes to various settings in SSMS. Now that you have SSMS configured exactly to your liking, you need to save all of these configuration settings. You know, in case you have to start over with a fresh install. Thankfully, saving SSMS settings is very easy. […]

When you are performance tuning code, you will frequently examine the execution plans to see what is happening. As you change the code, you will look at the execution plan again. However, comparing all the changes is troublesome. Fortunately, comparing query plans has become easy in SSMS (starting in 2016). Just save off the first […]

We all know that we should liberally document our code with comments, so that others (and even yourself) will know what the code is doing down the road. I like to start all of my code off with my classic remark block:

Note that this is a SQL Prompt snippet, not a snippet from […]

One of the things that I do with my code is to include reference links to what I was doing where applicable. SSMS provides us with a way to navigate directly to these web links, instead of having to copy the link and paste it into your browser. All that is needed for this is […]

Bookmarks are used in SSMS to have SSMS remember selected line positions, and to quickly move between the bookmarks. All of the Bookmark functionality is in the Bookmarks submenu, off of the Edit menu: A bookmark is toggled with the Ctrl+K, Ctrl+K keyboard shortcut, or by using the menu option shown. When the bookmark is […]

There are many editing items in SSMS that makes formatting and navigating your code easier than ever. Most of these Quick Editing Tips that follow are available from the Advanced submenu on the Edit menu: Ctrl+Up/Down Arrow Keys will scroll the window up or down. ALT+Up/Down Arrow Keys will move the selected line(s) up or […]

SSMS supports Outlining, the ability to selective hide blocks of code. This can be very useful, especially when working with large query files. In the following screen shot, the indicated box is what you click to show / hide the selected region. In this case, if I were to click the box (which has a […]

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.