Here are a few useful SSMS shortcuts:
| Ctrl-N | Open a new tabbed query window (with same credentials as current tab) |
| Ctrl–K + Ctrl–C / Ctrl–K + Ctrl–U | Comment / Uncomment selected text |
| Ctrl-Shift-U / Ctrl-Shift-L | Change selected text to upper / lowercase (wish it just affected keywords!) |
| Ctrl-L | Include estimated execution plan |
| Ctrl-K | Include actual execution plan |
| Ctrl+R | Toggle Results pane |
| F4 | Show Properties window |
| Ctrl+Shift+M | Specify values for template parameters |
Usual Suspects
Ctrl-F, Ctrl-H : Find/Replace
F5 or Ctrl-E : Execute query