Denali — Day 11: SSMS enhancement
SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA to manage the system efficiently.
Like IntelliSense/Debug is introduced in sql server 2008 now in Denali it has improved.
Following are some of the new features added in management studio:
- snippet – templates
now you can easily insert the snippets like if you want to create function/trigger/index/table… just insert the snippet syntax will automatically inserted for it.
Just right click the cursor and select “insert snippet” or Ctrl+K+X
You can add your own Snippets using “Tools-> Code Snippets Manager…” or Ctrl+K+B
- Surround With
This is another great feature of management studio where if you want to write a script and use surround with conditional statement like Begin, if, while.etc you can use the surround with option where the template of the script will be automatically set.
Just right click the cursor and select ” Surround With:” or Ctrl+K+S
This makes new bee very handy scripts /template and no need to remember the syntax of particular command.
- Cycle Clipboard Ring:
Most of the time you want to keep more than one text/commands to be copied and pasted if required but you could only copy last copied object and paste it, but now Denali introduced “Cycle Clipboard Ring” where you could copy multiple text and paste clipboard with Ring just press Ctrl+Shift+V (Edit – > Cycle Clipboard Ring)
Till now IntelliSense is provide you the help on the first character, but now you could get the help for any related character
Eg. If you press
Select * from physical
It will show you dm_db_index_pysical_stats
This way it is very easy for you to get the dmv instead of remembering the dmv’s.
You can get the quick information about the objects by just moving the cursor on an object and it will show.
Till now page restore is only available using T-Sql now from Denali you can use page restore using SSMS, with GUI it is easy to use.
Just goto database and right click and select Task->Restore->Page