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

Archives: January 2018

SSMS Activity Monitor (Day 31)

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… Read more

1 comments, 481 reads

Posted in A Discussion of SQL Server-Related Topics on 31 January 2018

Reports in SSMS (Day 30)

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… Read more

0 comments, 357 reads

Posted in A Discussion of SQL Server-Related Topics on 30 January 2018

Presenting with SSMS (Day 29)

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… Read more

1 comments, 493 reads

Posted in A Discussion of SQL Server-Related Topics on 29 January 2018

Saving SSMS Settings (Day 28)

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… Read more

0 comments, 312 reads

Posted in A Discussion of SQL Server-Related Topics on 28 January 2018

Comparing Query Plans (Day 27)

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).… Read more

1 comments, 362 reads

Posted in A Discussion of SQL Server-Related Topics on 27 January 2018

A month of SSMS tips and tricks

Wayne’s Tips and Tricks for SSMS

SQL Server Management Studio (SSMS ) is a program that many just launch daily (or only when they restart their computer), and they use it to navigate to various SQL Servers to manage them, either through the GUI or through a query. I’ve found… Read more

6 comments, 547 reads

Posted in A Discussion of SQL Server-Related Topics on 26 January 2018

Working with Comments (Day 26)

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:

/******************************************************************************
$SELECTIONSTART$Description of code$SELECTIONEND$
*******************************************************************************
                               MODIFICATION LOG
*******************************************************************************…

Read more

5 comments, 314 reads

Posted in A Discussion of SQL Server-Related Topics on 26 January 2018

Using the SSMS Web Browser (Day 25)

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… Read more

1 comments, 258 reads

Posted in A Discussion of SQL Server-Related Topics on 25 January 2018

Using the SSMS Web Browser (Day 25)

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… Read more

1 comments, 251 reads

Posted in A Discussion of SQL Server-Related Topics on 25 January 2018

Using Bookmarks to navigate code in SSMS (Day 24)

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… Read more

1 comments, 298 reads

Posted in A Discussion of SQL Server-Related Topics on 24 January 2018

Using Bookmarks to navigate code in SSMS (Day 24)

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… Read more

1 comments, 271 reads

Posted in A Discussion of SQL Server-Related Topics on 24 January 2018

Quick Editing Tips (Day 23)

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… Read more

3 comments, 129 reads

Posted in A Discussion of SQL Server-Related Topics on 23 January 2018

Quick Editing Tips (Day 23)

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… Read more

3 comments, 240 reads

Posted in A Discussion of SQL Server-Related Topics on 23 January 2018

Outlining (Day 22)

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… Read more

1 comments, 274 reads

Posted in A Discussion of SQL Server-Related Topics on 22 January 2018

Outlining (Day 22)

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… Read more

1 comments, 89 reads

Posted in A Discussion of SQL Server-Related Topics on 22 January 2018

Object Explorer Details (Day 21)

The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects that are in the selected node in the Object Explorer window. While the Object Explorer Details window does give you some useful information, it can be made better! This is… Read more

2 comments, 87 reads

Posted in A Discussion of SQL Server-Related Topics on 21 January 2018

Object Explorer Details (Day 21)

The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects that are in the selected node in the Object Explorer window. While the Object Explorer Details window does give you some useful information, it can be made better! This is… Read more

2 comments, 313 reads

Posted in A Discussion of SQL Server-Related Topics on 21 January 2018

Object Explorer Filtering (Day 20)

If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in the Object Explorer can be a pain. Thankfully, SSMS allows you to apply filtering criteria to this. Just right-click on the node that you want to filter, select Filter, and… Read more

1 comments, 351 reads

Posted in A Discussion of SQL Server-Related Topics on 20 January 2018

Object Explorer Filtering (Day 20)

If you have a database with hundreds (or thousands) of objects, finding the one that you are looking for in the Object Explorer can be a pain. Thankfully, SSMS allows you to apply filtering criteria to this. Just right-click on the node that you want to filter, select Filter, and… Read more

1 comments, 84 reads

Posted in A Discussion of SQL Server-Related Topics on 20 January 2018

Use Snippets in SSMS to insert blocks of code (Day 19)

Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just right-click in the query window and select “Insert Snippet”, or you can use the keyboard shortcut Ctrl+K, Ctrl+X.

Snippets allow you to store and easily reuse TSQL code snippets. To use a snippet, just… Read more

1 comments, 135 reads

Posted in A Discussion of SQL Server-Related Topics on 19 January 2018

Older posts