Are You Using SSMS effectively ?

Template Explorer

Let us say you want write a DDL trigger but you do not remember the correct syntax for creating a DDL Trigger (which is different than a regular trigger).

You can use the Template Explorer to assist you in this. The Template Explorer launched by selecting View > Template Explorer. This provides a very comprehensive listing of T-SQL templates for common tasks.

If you double click the template you want , relevant template will be opened.

By clicking Shift+Ctrl+M, you will get the option of entering template parameters, so that those can be entered in once place.

You can create your own template with parameters using the following format.

<database_name, sysname, AdventureWorks>

In the above example, database_name is the parameter name, sysname is the data type and the adventureworks is the default value.

Short Cuts

There are a few task that you will most likely perform daily such as viewing table structures or viewing indexes. You can create customized short cuts for these tasks. Select Tools > Options > Keyboard and you will be taken to following window.

By way of example, when analyzing your table structure, indexes you could do this by going to the object explorer and expanding the table. However, this is time consuming since to obtain the table structure, index information you need to navigate several pages. Instead simply hit ALT + F1 and you will see all the relevant information for that particular table. Note that for this short cut might have an issue, if you are using not default schema (ex:dbo), for these cases  you need your objects to be enclosed with quotes. ( ‘ HumanResources].[Employee]’).

Pages: 1 2




Related Articles :

One Response to “Are You Using SSMS effectively ?”

  1. Before this, I hvae never used the filter option in SSMS. Thanks for letting me know.

    ===========================================
    Better try and fail, instead of not trying at all…

    databasebestpractices.com

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |