Recently I have been on the LEAN improvement quest to make a 2 second improvement in my process every day.
Part of that improvement is to avoid switching to the mouse when you don’t have to. Here are some shortcut keys that I find very useful in SQL Server Management Studio, some of which I just discovered recently.
Window + L – Lock my Computer
F5 – My all time favorite – in a query window execute the query.
CTRL+M – Turn on/off Actual Execution Plan
CTRL-F6 switch between top tabs
F6 switch between tabs (ie Editor, Results, Messages…)
CTRL-TAB window manager
Alt+F1 for sp_help and a list of its fields
CTRL+SHIFT+U – shift word to uppercase
CTRL+SHIFT+L – shift word to lowercase
Ctrl+K+C – Comment block of text
Ctrl+K+U – UnCommnet block of text
What are your favorite keyboard shortcuts in SSMS?
Please post your favorites.
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Ctrl-K-C (Comment block of text)
Ctrl-K-U (UnCommnet block of text)
CTRL + K then C will comment all selected text
CTRL + K then U will uncomment all selected text
Very handy when commenting out large sections of code.
CTRL + SHIFT + M, template parameters. You need to specify placeholders in the code to begin with but I found it useful when creating code templates and maintaining a coding standard without forcing the developer to spend time formatting some parts of the code and any comments.