This is the first article from me to this site and first DBA article for the site. So I thought of playing little defensive (In cricket, if it is a new ground, coaches advice you to play defensively at starting. So I take a leaf out of the cricket coaching manual).
This topic might be a simple thus very important. Shortcuts are very important. When coping and paste you know how it is very easy when using CTRL+C and CTRL+V. Similarly, in SQL Server Management Studio (SSMS) there short cuts and there is way to have your own customized short cuts.
If you select Options from the Tools menu you will be taken to the following screen.
In the screen, you will see there are few short cuts. These shortcuts are included by me and no means the final and completed list. You can tell us what are your favorites and frequently used shortcuts.
Ok, now let us examine how these are used in practice.
Say, one of your developers sent you a request saying that, there is a performance issue with one of the stored procedure. So he has sent you the stored procedure name.
Let us say that proc is GetServiceFeesForDoctor. First task is to find out the SP from the object explorer. In most of the cases, there will be thousands of SPs thus it will be difficult to locate it from the object explorer.
However, short cut can be used. Copy the procedure name to the SSMS and press CTRL +F1 following will be the output.
You simply need to copy the results and paste it and your procedure is ready for analysis.
While analyzing your procedure, there are several tables. For further analysis, you need the table structure, indexes. Possible way of doing this is go to the object explorer and expand the table. However, this is time consuming since get table structure, index information you need to navigate several pages. Instead simply ALT + F1 and you will see all the relevant information for that particular table.
Next is you might need to see some records for the table. Instead of going to another pane, simply press CTRL +4 and you will see some records.
Next you might want to see what the procedures that are used by this table are. By simply clicking CTRL+3, you will the procedures used by this table.
As said before, these short cuts are no means completed and you can use any stored procedure, or even your customized stored procedures to support.