Shortcuts help you to do your work swiftly and with increased productivity. In this blog we’ll look at new query window shortcut every SQL Server geek should know

Shortcut Usage
Window + R -> ssms.exe Open SQL Server management studio

1_SQL Server new query window shortcut

CTRL + N Open a new query window

2_SQL Server new query window shortcut

CTRL + TAB Move among open query windows

3_SQL Server new query window shortcut

CTRL + E Execute All or selected queries
Ctrl + Shift + U Convert selected text to upper case
Ctrl + Shift + L Convert selected text to lower case
Ctrl + L Display estimated execution plan

5_SQL Server new query window shortcut

Ctrl +Space Intellisence – list members
CTRL + R Show/Hide Result pane
Ctrl + M Display Actual execution plan

6_SQL Server new query window shortcut

Ctrl + G Go to a particular line number

7_SQL Server new query window shortcut

Alt + Break Cancel executing query

4_SQL Server new query window shortcut

Ctrl + K, Ctrl + C Comment selected lines

8_SQL Server new query window shortcut

Ctrl + K, Ctrl + U Uncomment selected lines

9_SQL Server new query window shortcut

F5 Execute all or selected queries in current query window
Alt Switch to query window menu
Ctrl + K, Ctrl + X Insert snippet

10_SQL Server new query window shortcut

Shift + Ctrl + Enter Toggle between full screen and normal window

11_SQL Server new query window shortcut

Ctrl + T, Ctrl + E Execute all or selected queries in current query window and display results in Text format
Ctrl + D, Ctrl + E Execute all or selected queries in current query window and display results in Grid format

 

Note: The above shortcuts are tested on SQL Server 2014.

 

Regards

Ahmad Osama

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook