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

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, 86 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, 197 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, 249 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, 64 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, 65 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, 205 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, 245 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, 60 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, 72 reads

Posted in A Discussion of SQL Server-Related Topics on 19 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, 212 reads

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

Template Explorer (Day 18)

You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up a template for you to fill in – for instance, when creating a new stored procedure. Have you ever wondered where SSMS gets the template from? You can view all… Read more

1 comments, 193 reads

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

Template Explorer (Day 18)

You may have noticed that in many places in SSMS, you can create a new item and SSMS opens up a template for you to fill in – for instance, when creating a new stored procedure. Have you ever wondered where SSMS gets the template from? You can view all… Read more

1 comments, 31 reads

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

Add color to connections (Day 17)

Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well, you can change the status bar to any color that you want for any instance.

In the Connect to Server dialog, select the Options button.

Then select the “Connection Properties”… Read more

1 comments, 66 reads

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

Add color to connections (Day 17)

Have you ever wished for a visual indicator that you are connected to a production instance of SQL Server? Well, you can change the status bar to any color that you want for any instance.

In the Connect to Server dialog, select the Options button.

Then select the “Connection Properties”… Read more

1 comments, 236 reads

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

Assign a keyboard shortcut to menu items (Day 16)

You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode under the query menu. You can easily add a keyboard shortcut to any menu item that you desire. Just right-click on the toolbar, and select customize. Then select Keyboard:

Search… Read more

2 comments, 194 reads

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

Assign a keyboard shortcut to menu items (Day 16)

You may have noticed that there are many menu commands that don’t have a keyboard shortcut. For instance, SQLCMD mode under the query menu. You can easily add a keyboard shortcut to any menu item that you desire. Just right-click on the toolbar, and select customize. Then select Keyboard:

Search… Read more

2 comments, 40 reads

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

Query Shortcuts in SSMS (Day 15)

There are several shortcuts that can be assigned to run a stored procedure. Known as Query Shortcuts, these can be assigned to the Alt+F1, Ctrl+F1 and the Ctrl+# keys.

For instance, highlight sys.databases below and press Alt+F1. sp_help will run against sys.databases, and it will produce the following output:

This… Read more

1 comments, 196 reads

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

Object Explorer Drag-N-Drop (Day 14)

Did you know that items in the Object Explorer can be dragged and dropped into a query window? This can be a real time saver!

Drag the database name to have it put into the query window. Grab the table name and drag it to the FROM clause. Drag the… Read more

0 comments, 150 reads

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

The SSMS Super Clipboard (Day 13)

We’re all used to using the clipboard in Windows programs. You copy something into it with Ctrl+C, and paste it into your document with Ctrl+V. However, did you know that the SSMS clipboard remembers the last 20 items that were put into the clipboard, and that you can cycle through… Read more

1 comments, 247 reads

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

Changing Case (Day 12)

In yesterday’s tip, I showed an example of changing a block of text from upper case to lower case. However, I didn’t show how to actually change the text.

Just select the text, and use the keyboard shortcuts Ctrl+Shift+U or Ctrl+Shift+L to change the text to upper case or lower… Read more

1 comments, 163 reads

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

Newer posts

Older posts