SQL Server new query window shortcut

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
CTRL + N	Open a new query window
CTRL + TAB	Move among open query windows
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
Ctrl +Space	Intellisence – list members
CTRL + R	Show/Hide Result pane
Ctrl + M	Display Actual execution plan
Ctrl + G	Go to a particular line number
Alt + Break	Cancel executing query
Ctrl + K, Ctrl + C	Comment selected lines
Ctrl + K, Ctrl + U	Uncomment selected lines
F5	Execute all or selected queries in current query window
Alt	Switch to query window menu
Ctrl + K, Ctrl + X	Insert snippet
Shift + Ctrl + Enter	Toggle between full screen and normal window
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.