All About .Net

Tuesday, October 11, 2016

Sql server 2016 keyboard shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Move to the SQL Server Management Studio menu bar	ALT	ALT
Activate the menu for a tool component	ALT+HYPHEN	ALT+HYPHEN
Display the context menu	SHIFT+F10	SHIFT+F10
Display the New File dialog box to create a file	CTRL+N	CTRL+N
Display the New Project dialog box to create a new project	CTRL+SHIFT+N	CTRL+SHIFT+N
Display the Open File dialog box to open an existing file	CTRL+O or CTRL+SHIFT+G	CTRL+O
Display the Open Project dialog box to open an existing project	CTRL+SHIFT+O	CTRL+SHIFT+O
Display the Add New Item dialog box to add a new file to the current project	CTRL+SHIFT+A	CTRL+SHIFT+A
Display the Add Existing Item dialog box to add an existing file to the current project	SHIFT+ALT+A	SHIFT+ALT+A
Display the Query Designer	CTRL+SHIFT+Q	CTRL+SHIFT+Q
Close a menu or dialog box, canceling the action	ESC	ESC

Windows Management and Toolbar Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Close the current MDI child window	CTRL+F4	CTRL+F4
Close a menu or dialog box, cancels an operation in progress, or focuses on the current document window	ESC	ESC
Print	CTRL+P	CTRL+P
Exit	ALT+F4	ALT+F4
Toggle full screen mode	SHIFT+ALT+ENTER	SHIFT+ALT+ENTER
Close the current tool window	SHIFT+ESC	SHIFT+ESC
Cycle through the next MDI child windows	CTRL+F6	CTRL+TAB
Display the IDE navigator with the first document window selected	CTRL+TAB	No equivalent
Cycle through the previous MDI child windows	CTRL+SHIFT+TAB	CTRL+SHIFT+TAB
Moves the insertion point to the drop-down bar located at the top of the code editor when the editor is in Code view or Server Code view	CTRL+F2	No equivalent
Move to the current tool window toolbar	SHIFT+ALT	SHIFT+ALT
Display the IDE navigator with the first tool window selected	ALT+F7	No equivalent
Move to the next tool window	ALT+F6 or F6 in the Database Engine Query Editor	ALT+F6
Move to the previous tool window	SHIFT+ALT+F7	SHIFT+ALT+F7
Move to the next pane of a split pane view of a single document	F6	F6
Move to the previously selected window	SHIFT+ALT+F6 or SHIFT+F6 in the Database Engine Query Editor	SHIFT+ALT+F6
Move to the previous pane of a split pane view of a single document	SHIFT+F6	F6
Display the dock menu	ALT+MINUS SIGN (-)	No equivalent
Display a popup listing all open windows	CTRL+ALT+DOWN ARROW	No equivalent
Opens a new query editor window	CTRL+O	CTRL+O
Display Object Explorer	F8	F8
Display Registered Servers	CTRL+ALT+G	CTRL+ALT+G
Display Template Explorer	CTRL+ALT+T	CTRL+ALT+T
Display Solution Explorer	CTRL+ALT+L	CTRL+ALT+L
Display the Summary Window	F7	F7
Display the Properties Window	F4	F4
Display the Output window	CTRL+ALT+O	No equivalent
Display the Task List window	CTRL+\, T or CTRL+\, CTRL+T	CTRL+ALT+K
Toggle between Object Explorer Details list view and Object Explorer Details property pane.	F6	F6
Control the splitter bar that separates the Object Explorer Details list view and Object Explorer Details property pane to adjust the size of the display pane.	TAB, then UP arrow or DOWN arrow	TAB, then UP arrow or DOWN arrow
Display the Toolbox	CTRL+ALT+X	CTRL+ALT+X
Display the Bookmarks Window	CTRL+K, CTRL+W	CTRL+K, CTRL+W
Display the Browser Window	CTRL+ALT+R	CTRL+ALT+R
Display a smart tag menu of common commands for Web server controls in the HTML designer	SHIFT+ALT+F10	No equivalent
Display the Error List Window (Transact-SQL Editor only)	CRTL+\, CTRL+E or CTRL+\, E	CRTL+\, CTRL+E
Move to the next entry in the Error List window (Transact-SQL Editor only)	CTRL+SHIFT+F12	CTRL+SHIFT+F12
Display the previous page in the viewing history. Available only in the Web browser window	ALT+LEFT ARROW	No equivalent
Display the next page in the viewing history. Available only in the Web browser window	ALT+RIGHT ARROW	No equivalent

Cursor Movement Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Move the cursor left	LEFT ARROW	LEFT ARROW
Move the cursor right	RIGHT ARROW	RIGHT ARROW
Move the cursor up	UP ARROW	UP ARROW
Move the cursor down	DOWN ARROW	DOWN ARROW
Move the cursor to the beginning of the line	HOME	HOME
Move the cursor to the end of the line	END	END
Move the cursor to the beginning of the document	CTRL+HOME	CTRL+HOME
Move the cursor to the end of the document	CTRL+END	CTRL+END
Move the cursor up one screen	PAGE UP	PAGE UP
Move the cursor down one screen	PAGE DOWN	PAGE DOWN
Moves the cursor one word to the right	CTRL+ RIGHT ARROW	CTRL+ RIGHT ARROW
Moves the cursor one word to the left	CTRL+ LEFT ARROW	CTRL+ LEFT ARROW
Returns the cursor to the last item.	SHIFT+F8	No equivalent
Moves the cursor to the top of the document	CTRL+PAGE UP	No equivalent
Moves to the previous tab in the document	CTRL+PAGE UP
Moves the cursor to the bottom of the document	CTRL+PAGE DOWN	No equivalent
Moves to the next tab in the document	CTRL+PAGE DOWN	No equivalent

Text Selection Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Select text from the cursor to the beginning of the document	CTRL+SHIFT+ HOME	CTRL+SHIFT+ HOME
Select text from the cursor to the end of the document	CTRL+SHIFT+END	CTRL+SHIFT+END
Select text from the cursor to the start of the current line	SHIFT+HOME	SHIFT+HOME
Moves the cursor to the start of the current line and extends the column selection	SHIFT+ALT+HOME	No equivalent
Select text from the cursor to the end of the current line	SHIFT+END	SHIFT+END
Moves the cursor to the end of the line, extending the column selection.	SHIFT+ALT+END	No equivalent
Select text down line by line starting from the cursor	SHIFT+ DOWN ARROW	SHIFT+ DOWN ARROW
Moves the cursor down one line, extending the column selection	SHIFT+ Ctrl+Shift+Del
Moves the cursor one character to the left and extends the selection	SHIFT+LEFT ARROW	No equivalent
Moves the cursor one character to the left and extends the column selection	SHIFT+ALT+LEFT ARROW	No equivalent
Moves the cursor one character to the right and extends the selection	SHIFT+RIGHT ARROW	No equivalent
Moves the cursor one character to the righTt and extends the column selection	SHIFT+ALT+RIGHT ARROW	No equivalent

Select text up line by line starting from the cursor	SHIFT+UP ARROW	SHIFT+UP ARROW
Move the cursor up one line, extending the selection	SHIFT+ALT+ UP ARROW	SHIFT+ALT+ UP ARROW
Extend selection up one page	SHIFT+ PAGE UP	SHIFT+ PAGE UP
Extend selection down one page	SHIFT+ PAGE DOWN	SHIFT+ PAGE DOWN
Select the entire current document	CTRL+A	CTRL+A
Select the word containing the cursor, or the closest word	CTRL+W	CTRL+W
Select the current location in the editor, back to the previous location in the editor	CTRL+=	CTRL+=
Extend the selection to the top of the current window	CTRL+SHIFT+ PAGE UP	CTRL+SHIFT+ PAGE UP
Move the cursor to the last line in view, extending the selection	CTRL+SHIFT+ PAGE DOWN	CTRL+SHIFT+ PAGE DOWN
Extend the selection one word to the right	CTRL+SHIFT+ RIGHT ARROW	CTRL+SHIFT+ RIGHT ARROW
Extend the selection one word to the left	CTRL+SHIFT+ LEFT ARROW	CTRL+SHIFT+ LEFT ARROW
Move the cursor to the right one word, extending the selection	CTRL+SHIFT+ALT+ RIGHT ARROW	CTRL+SHIFT+ALT+ RIGHT ARROW
Move the cursor to the left one word, extending the selection	CTRL+SHIFT+ALT+ LEFT ARROW	CTRL+SHIFT+ALT+ LEFT ARROW
Move the cursor to the next brace, extending the selection	CTRL+SHIFT+]	No equivalent
Select the text from the current location of the cursor to the Navigate Backward (CTRL+MINUS SIGN (-)) location	CTRL+EQUAL SIGN (=)	No equivalent
Go back to the previous document or window in the navigation history	CTRL+MINUS SIGN (-)	No equivalent
Go forward to the next document or window in the navigation history	CTRL+SHIFT+MINUS SIGN (-)	No equivalent
Swaps the anchor and end points of the current selection	CTRL+K, CTRL+A	No equivalent
Moves the cursor to the first line in view, extending the selection	CTRL+SHIFT+PAGE UP	No equivalent
Moves the cursor to the last line in view, extending the selection	CTRL+SHIFT+PAGE DOWN	No equivalent

Bookmark Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Set or remove a bookmark at the current line	CTRL+K, CTRL+K	CTRL+K, CTRL+K
Next bookmark	CTRL+K, CTRL+N	CTRL+K, CTRL+N
If the current bookmark is in a folder, moves to the next bookmark in the folder. Bookmarks outside the folder are skipped. If the bookmark is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped.	CTRL+SHIFT+K, CTRL+SHIFT+N	No equivalent
Previous bookmark	CTRL+K, CTRL+P	CTRL+K, CTRL+P
If the current bookmark is in a folder, moves to the next bookmark in the folder. Bookmarks outside the folder are skipped. If the bookmark is not in a folder, moves to the next bookmark at the same level. If the Bookmarks window contains folder, bookmarks in folders are skipped.	CTRL+SHIFT+K, CTRL+SHIFT+P	No equivalent
Clear bookmarks	CTRL+K, CTRL+L	CTRL+K, CTRL+L

Tree Control Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Collapse tree nodes	- (on the numeric keypad)	- (on the numeric keypad)
Expand all tree nodes	* (on the numeric keypad)	* (on the numeric keypad)
Scroll the tree control up in the window	CTRL+UP ARROW	CTRL+UP ARROW
Scroll the tree control down in the window	CTRL+DOWN ARROW	CTRL+DOWN ARROW

Code Editor Keyboard Shortcuts

All shortcuts are not implemented in all types of code editors.

Action	SQL Server 2016	SQL Server 2008 R2
Toggle the full-screen display	SHIFT+ALT+ENTER	SHIFT+ALT+ENTER
Scroll text up one line	CTRL+UP ARROW	CTRL+UP ARROW
Scroll text down one line	CTRL+DOWN ARROW	CTRL+ DOWN ARROW
Reverse the last editing action	CTRL+Z or ALT+BACKSPACE	CTRL+Z
Restore the previously undone edit	CTRL+SHIFT+Z or CTRL+Y or ALT+SHIFT+BACKSPACE	CTRL+SHIFT+Z or CTRL+Y or ALT+SHIFT+BACK SPACE
Save the selected item	CTRL+S	CTRL+S
Save all	CTRL+SHIFT+S	CTRL+SHIFT+S
Close	CTRL+F4	CTRL+F4
Print	CTRL+P	CTRL+P
Exit	ALT+F4	ALT+F4
Open the current file in a browser	CTRL+SHIFT+W	No equivalent
Delete all text in the current file	CTRL+SHIFT+DEL	CTRL+SHIFT+DEL
Display the Go To Line dialog box	CTRL+G	CTRL+G
Display the Navigate To dialog box.	CTRL+PLUS SIGN (+)	No equivalent
Increase line indent	TAB	TAB
Decrease line indent	SHIFT+TAB	SHIFT+TAB
Make the selected text upper case	CTRL+SHIFT+U	CTRL+SHIFT+U
Make the selected text lower case	CTRL+U	CTRL+SHIFT+L
Make the selected text a comment	CTRL+K, CTRL+C	CTRL+K, CTRL+C
Uncomment the selected text	CTRL+K, CTRL + U	CTRL+K, CTRL + U
Open a new query with current connection	CTRL+N	CTRL+N
Open database in Object Explorer	ALT+F8	ALT+F8
Specify values for template parameters	CTRL+SHIFT+M	CTRL+SHIFT+M
Run the selected portion of the query editor or the entire query editor if nothing is selected	F5 or CTRL+SHIFT+E	F5 or CTRL+E or ALT+X
Parse the selected portion of the query editor or the entire query editor if nothing is selected	CTRL+F5	CTRL+F5
Display the estimated execution plan	CTRL+SHIFT+ALT+L	CTRL+L
Cancel the executing query	ALT+BREAK	ALT+BREAK
Include actual execution plan in the query output	CTRL+SHIFT+ALT+M	CTRL+M
Output results in a grid	CTRL+SHIFT+D	CTRL+D
Output results in text format	CTRL+T	CTRL+T
Output results to a file	CTRL+SHIFT+T	CTRL+SHIFT+F
Show or hide the query results pane	CTRL+R	CTRL+R
Show the query results pane	CTRL+SHIFT+ALT+R
Toggle between query and results pane	F6	F6
Copy the result grid and headers to the clipboard	CTRL+SHIFT+C	No equivalent
Move to the next active window in Management Studio	ALT+F6	ALT+F6
Open SQL Server Profiler	CTRL+ALT+P	CTRL+ALT+P
Display the Query Designer dialog from the query editor window	CTRL+SHIFT+Q	No equivalent
Run the sp_help system stored procedure	ALT+F1	ALT+F1
Run the sp_who system stored procedure	CTRL+1	CTRL+1
Run the sp_lock system stored procedure	CTRL+2	CTRL+2
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+3	CTRL+3
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+4	CTRL+4
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+5	CTRL+5
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+6	CTRL+6
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+7	CTRL+7
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+7	CTRL+7
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+8	CTRL+8
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+9	CTRL+9
Run the stored procedure configured for this shortcut in the Tools, Options, Keyboard, Query Shortcuts dialog	CTRL+0	CTRL+0

Text Manipulation in Code Editor Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Insert a new line	ENTER or SHIFT+ENTER	ENTER or SHIFT+ENTER
Swap the characters on either side of the cursor (Does not apply to the SQL Editor.)	CTRL+T	CTRL+T
Delete one character to the right of the cursor	DELETE	DELETE
Delete one character to the left of the cursor	BACKSPACE or SHIFT+ BACKSPACE	BACKSPACE or SHIFT+ BACKSPACE
Delete whitespace in the selection, or deletes whitespace adjacent to the cursor if there is no selection	CTRL+K, C	No equivalent
Insert the number of spaces configured for the editor	TAB	TAB
Insert a blank line above the cursor	CTRL+ENTER	CTRL+ENTER
Insert a blank line below the cursor	CTRL+SHIFT+ ENTER	CTRL+SHIFT+ ENTER
Change the selected text to lowercase	CTRL+SHIFT+L	CTRL+SHIFT+L
Change the selected text to uppercase	CTRL+SHIFT+U	CTRL+SHIFT+U
Toggle between insert mode and overtype mode	INSERT	INSERT
Move selected lines to the left on tab stop	SHIFT+TAB	SHIFT+TAB
Delete the word to the right of the cursor	CTRL+DELETE	CTRL+DELETE
Delete the word to the left of the cursor	CTRL+BACKSPACE	CTRL+BACKSPACE
Transpose the words on either side of the cursor (Does not apply to the SQL Editor.)	CTRL+SHIFT+T	CTRL+SHIFT+T
Moves the line containing the cursor below the next line	SHIFT+ALT+T	No equivalent
Applies the indenting and space formatting for the language specified on the Formatting pane of the language in the Text Editor section of the Options dialog. Available only in the text editor.	CTRL+K, CTRL+D	No equivalent
Correctly indents the selected lines of code based on the surrounding lines of code	CTRL+K, CTRL+F	No equivalent
Set or remove a shortcut in the current line	CTRL+K, CTRL+H	No equivalent
Remove the comment syntax from the current line	CTRL+K, CTRL+U	No equivalent
Shows or hides spaces and tabs	CTRL+R, CTRL+W	No equivalent
Enables or disables word wrap in an editor	Alt+F, CTRL+W	No equivalent
Collapses all outlining regions to show just the outermost groups in the hierarchy	CTRL+M, CTRL+A	No equivalent
Collapses the currently selected outlining region	CTRL+M, CTRL+S	No equivalent
Expands all outlining regions on the page	CTRL+M, CTRL+X	No equivalent
Expands the currently selected outlining region	CTRL+M, CTRL+E	No equivalent
Collapses existing outlining regions	CTRL+M, CTRL+O
Hides the selected text. A signal icon marks the location of the hidden text	CTRL+M, CTRL+H	No equivalent
Toggles all text sections previously marked as hidden between the hidden and display states.	CTRL+M, CTRL+L	No equivalent
Toggles the currently selected hidden text section between the hidden and display states	CTRL+M, CTRL+M	No equivalent
Removes all outlining information in the document	CTRL+M, CTRL+P	No equivalent
Removes the outlining information for the currently selected region	CTRL+M, CTRL+U	No equivalent

Transact-SQL Debugger Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Start or continue debugging	ALT+F5	ALT+F5
Stop debugging	SHIFT+F5	SHIFT+F5
Step into	F11	F11
Step over	F10	F10
Step out	SHIFT+F11	SHIFT+F11
Step into specific statement	SHIFT+ALT+F11	No equivalent
Set next statement	Ctrl+3 0	No equivalent
Show next statement	ALT+NUM	No equivalent
Implement the Run To Cursor command	CTRL+F10	CTRL+F10
Display the QuickWatch dialog box	CTRL+ALT+Q or SHIFT+F9	CTRL+ALT+Q
Toggle breakpoint	F9	F9
Enable breakpoint	CTRL+F9	No equivalent
Delete the breakpoint. Only available in the Breakpoints window	ALT+F9, D	No equivalent
Open the Edit breakpoint labels dialog. Only available in the Breakpoints window	ALT+F9, L	No equivalent
Delete all breakpoints	CTRL+SHIFT+F9	CTRL+SHIFT+F9
Display the Breakpoints window	CTRL+ALT+B	CTRL+ALT+B
Break all	CTRL+ALT+BREAK	CTRL+ALT+BREAK
Break at function	CTRL+B	No equivalent
Display the Watch 1 window	CTRL+ALT+W, 1	No equivalent
Display the Watch 2 window	CTRL+ALT+W, 2	CTRL+ALT+W, 1
Display the Watch 3 window	CTRL+ALT+W, 3	CTRL+ALT+W, 3
Display the Watch 4 window	CTRL+ALT+W, 4	CTRL+ALT+W, 4
Display the Autos window	CTRL+ALT+V, A	CTRL+ALT+V, A
Display the Locals window	CTRL+ALT+V, L	CTRL+ALT+V, L
Display the Immediate window	CTRL+ALT+I	CTRL+ALT+I
Display the Call Stack window	CTRL+ALT+C	CTRL+ALT+C
Display the Threads window	CTRL+ALT+H	CTRL+ALT+H
Display the Parallel Stacks window.	CTRL+SHIFT+D, S	No equivalent
Display the Parallel Tasks window	CTRL_SHIFT+D, K	No equivalent

Microsoft IntelliSense Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
List members	CTRL+J	CTRL+SPACE or CTRL+J
Complete word	CTRL+SPACE or ALT+RIGHT ARROW	ALT+RIGHT ARROW
Display quick information	CTRL+K, CTRL+I	No equivalent
Display parameter information	CTRL+SHIFT+SPACE	CTRL+SHIFT+SPACE
Copy parameter tip	CTRL+SHIFT+ALT+C	No equivalent
Paste parameter tip	CTRL+SHIFT+ALT+P	No equivalent
Jump between syntax pairs	CTRL+]	CTRL+]
Launch code snippet picker	CTRL+K, CTRL+X	CTRL+K, CTRL+Z
Refresh local cache	CTRL+SHIFT+R	CTRL+SHIFT+R
Launch Surround With snippet picker	CTRL+K, CTRL+S	CTRL+K, CTRL+S
Display the Code Snippet Manager	CTRL+K, CTRL+B	No equivalent
Changes the IntelliSense filter level from the Common tab to the All tab.	ALT+PLUS SIGN (+)	No equivalent
Changes the IntelliSense filter level from the All tab to the Common tab.	ALT+PERIOD (.)	No equivalent

Document Window and Browser Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Toggle full-screen mode	SHIFT+ALT+ENTER	SHIFT+ALT+ENTER
Move to the next pane of a split pane view of a document	F6	F6
Move to the previous document in the editor or designer	CTRL+SHIFT+F6 CTRL+SHIFT+TAB	CTRL+SHIFT+F6 CTRL+SHIFT+TAB
Move to the previous pane of a document in split pane view	SHIFT+F6	SHIFT+F6
Back, display the previous page in the viewing history	ALT+LEFTARROW	ALT+LEFTARROW
Forward, display the next page in the viewing history	ALT+RIGHTARROW	ALT+RIGHTARROW
Closes a menu or dialog box, cancels an operation in progress, or places focus in the current window	ESC	No equivalent

Solution Explorer Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Display Solution Explorer	CTRL+ALT+L	CTRL+ALT+L
Display the New File dialog box to create a new file	CTRL+N	CTRL+N
Display the New Project dialog box to create a new project	CTRL+SHIFT+N	CTRL+SHIFT+N
Display the Open File dialog box to open an existing file	CTRL+O	CTRL+O
Change the name of the selected object	F2	No equivalent

Help and Books Online Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Help	F1 or SHIFT+F1	F1
Display SQL Server Books Online	CTRL+F1	No equivalent
Open the Help Library Manager	CTRL+ALT+F1	No equivalent
Display the SQL Server Resource Center Web page	CTRL+ALT+F2	No equivalent
Display help for the current editor window	SHIFT+F1	No equivalent
Help on "How Do I"	No equivalent	CTRL+F1
Books Online Contents	No equivalent	CTRL+ALT+F1
Books Online Index	No equivalent	CTRL+ALT+F2
Help Search	No equivalent	CTRL+ALT+F3
Dynamic Help	No equivalent	CTRL+ALT+F4
Help Favorites	No equivalent	CTRL+ALT+F

Search Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Display the Find dialog box	CTRL+F	CTRL+F
Displays the In Files tab of the Find dialog box.
Displays the definition for the selected symbol.	F12	No equivalent
Displays the list of references for the selected symbol.	SHIFT+F12	No equivalent
Display the Replace dialog box	CTRL+H	CTRL+H
Start incremental search. Type the characters to search for or press CTRL+I to search for characters from the previous search	CTRL+I	CTRL+I
Find the next occurrence of the previous search text	F3	F3
Find the previous occurrence of the search text	SHIFT+F3	SHIFT+F3
Find the next occurrence of the currently selected text	CTRL+F3	CTRL+F3
Find the previous occurrence of the currently selected text	CTRL+SHIFT+F3	CTRL+SHIFT+F3
Display the Replace in Files dialog box	CTRL+SHIFT+H	CTRL+SHIFT+H
Reverse incremental search so it starts at the bottom of the file and searches to the top	CTRL+SHIFT+I	CTRL+SHIFT+I
Select or clear the Search up option in Find and Replace	ALT+F3, B	ALT+F3, B
Stop the Find in Files search	ALT+F3, S	ALT+F3, S
Select or clear the Find whole word option in Find and Replace	ALT+F3, W	ALT+F3, W
Selects or clears the Wildcard option in Find and Replace	ALT+F3, P	ALT+F3, P
Place the caret in the Find/Command box of the Standard toolbar	CTRL+/	No equivalent

Cut and Paste Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Cut (delete the currently selected item and place it to the Clipboard)	CTRL+X or SHIFTRLT+DELETE	CTRL+X or SHIFT+DELETE
Cuts all of the selected lines, or the current line if nothing is selected.	CTRL+L or CTRL+SHIFT+L	No equivalent
Copy to the Clipboard	CTRL+C or CTRL+INSERT	CTRL+C or CTRL+INSERT
Paste from the Clipboard at the insertion point	CTRL+V or SHIFT+INSERT	CTRL+V or SHIFT+INSERT
Pastes an item from the Clipboard Ring at the insertion point and automatically selects the pasted item	CTRL+SHIFT+V or CTRL+enseSHIFT+INSERT	No equivalent

Log Viewer Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Refresh	No equivalent	F5
Move between the Select logs pane and the Log file summary pane	No equivalent	F6
Move to the Log file summary pane	No equivalent	ALT+S
Load a new log	No equivalent	CTRL+SHIFT+L
Export a log	No equivalent	CTRL+SHIFT+E
Filter a log	No equivalent	CTRL+SHIFT+F
Search in a log	No equivalent	CTRL+SHIFT+S

Activity Monitor Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Launches Activity Monitor	CTRLl+ALT+A	CTRLl+ALT+A
Closes Activity Monitor	CTRL+F4	CTRL+F4
Refresh	F5	F5
Filter the monitor display	CTRL+SHIFT+F	CTRL+SHIFT+F
Cycle through panels	F6	F6
Expand or collapse selected pane	CTRL and + or -	CTRL and + or -
Expand or collapse all panes	+ or -	+ or -
Copies entire selected row in grid	CTRL+C	CTRL+C
Copy cell	CTRL+SHIFT+C	CTRL+SHIFT+C
Drop-down for filtering in grid	ALT+DOWN	ALT+DOWN
Scroll up or down Activity Monitor	CTRL+ALT+UP/DOWN	CTRL+ALT+UP/DOWN

Replication Monitor Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Refresh	F5	F5
Open a detail window from a grid	ENTER	ENTER

Replication Conflict Viewer Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Define filter	F6	F6
Apply filter	F7	F7
Show all columns	F8	F8

Query Designer Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Cancels or stops the currently running query	CTRL+T	CTRL+T
Displays the diagram pane of the Query Designer	CTRL+1	CTRL+1
Displays the criteria pane of the Query Designer	CTRL+2	CTRL+2
Displays the SQL pane of the Query Designer	CTRL+3	CTRL+3
Displays the results pane of the Query Designer	CTRL+4	CTRL+4
Run the query specified in the Query Designer	CTRL+R	CTRL+R
When in the results pane, moves focus to the tool strip docked at the bottom of the designer	CTRL+G	CTRL+G
Enables JOIN mode in the Query Designer	CTRL+SHIFT+J	CTRL+SHIFT+J

Designer Keyboard Shortcuts

Action	SQL Server 2016	SQL Server 2008 R2
Move the selected control down in increments of 8 on the design surface	DOWN ARROW	No equivalent
Move the selected control left in increments of 8 on the design surface	LEFT ARROW	No equivalent
Move the selected control right in increments of 8 on the design surface	RIGHT ARROW	No equivalent
Move the selected control up in increments of 8 on the design surface	UP ARROW	No equivalent
Increases the height of the selected control in increments of 8	SHIFT+DOWN ARROW	No equivalent
Reduces the width of the selected control in increments of 8	SHIFT+LEFT ARROW	No equivalent
Increases the width of the selected control in increments of 8	SHIFT+RIGHT ARROW	No equivalent
Decreases the height of the selected control in increments of 8	SHIFT+UP ARROW	No equivalent
Moves to the next control on the page	TAB	No equivalent
Moves to the previous control on the page	SHIFT+TAB	No equivalent
Display the grid on the design surface	ENTER	No equivalent

Visual Studio 2015 keyboard shortcuts

Analyze

Navigate Backward: Shift+Alt+3
Navigate Forward: Shift+Alt+4

Architecture

New Code Map: Ctrl+\, Ctrl+O
New UMLor Layer Diagram: Ctrl+\, Ctrl+N

Architecture Context Menus

Add Node: Ins
Both Dependencies: B
Incoming Dependencies: I
Outgoing Dependencies: O
New Comment: Ctrl+Shift+K; Ctrl+E, C
Remove: Del
Rename: F2

Build

Build Solution: Ctrl+Shift+B
Cancel: Ctrl+Break
Compile: Ctrl+F7
Run Code Analysison Solution: Alt+F11

Class Diagram

Collapse: Num -
Expand: Num +

Class View Context Menus

Properties: Alt+Enter

Misc

Commit All Edits: Shift+Alt+U
Move Left Edgetotheleft: Ctrl+Shift+,
Move Left Edgetotheright: Ctrl+Shift+.
Move Right Edgetotheleft: Ctrl+Shift+Alt+,
Move Right Edgetotheright: Ctrl+Shift+Alt+.
TSql Editor Clone Query: Ctrl+Alt+N
TSql Editor Database Combo: Shift+Alt+PgDn
View File In Script Panel: Shift+Alt+PgDn

Debug

Apply Code Changes: Alt+F10
Attachto Process: Ctrl+Alt+P
Autos: Ctrl+Alt+V, A
Break All: Ctrl+Alt+Break
Breakat Function: Ctrl+B
Breakpoints: Ctrl+Alt+B
Call Stack: Ctrl+Alt+C
Debug Windows Phone Internet Explorer: Ctrl+Shift+P
Delete All Breakpoints: Ctrl+Shift+F9
Launch: Alt+F2
Stop Collection: Ctrl+Alt+F2
Disassembly: Ctrl+Alt+D
Enable Breakpoint: Ctrl+F9
Exceptions: Ctrl+Alt+E
Go To Previous Callor Intelli Trace Event: Ctrl+Shift+F11
Start Diagnostics: Alt+F5
Immediate: Ctrl+Alt+I
Intelli Trace Calls: Ctrl+Alt+Y, T
Intelli Trace Events: Ctrl+Alt+Y, F
Java Script Console: Ctrl+Alt+V, C
Locals: Ctrl+Alt+V, L
Process Combo: Ctrl+5
Stack Frame Combo: Ctrl+7
Thread Combo: Ctrl+6
Toggle Current Thread Flagged State: Ctrl+8
Toggle Flagged Threads: Ctrl+9
Memory1: Ctrl+Alt+M, 1
Memory2: Ctrl+Alt+M, 2
Memory3: Ctrl+Alt+M, 3
Memory4: Ctrl+Alt+M, 4
Modules: Ctrl+Alt+U
Parallel Stacks: Ctrl+Shift+D, S
Parallel Watch1: Ctrl+Shift+D, 1
Parallel Watch2: Ctrl+Shift+D, 2
Parallel Watch3: Ctrl+Shift+D, 3
Parallel Watch4: Ctrl+Shift+D, 4
Show: Ctrl+Shift+D, D
Processes: Ctrl+Alt+Z
Quick Watch: Shift+F9; Ctrl+Alt+Q
Refresh: F5
Refresh Windowsapp: Ctrl+Shift+R
Registers: Ctrl+Alt+G
Restart: Ctrl+Shift+F5
Run To Cursor: Ctrl+F10
Select Element: Ctrl+B
Set Next Statement: Ctrl+Shift+F10
Show All: Ctrl+Alt+V, D
Show Call Stackon Code Map: Ctrl+Shift+`
Show Layout: Ctrl+Shift+I
Show Next Statement: Alt+Num *
Start: F5
Start Windows Phone Application Analysis: Alt+F1
Start Without Debugging: Ctrl+F5
Step Into: F11
Step Into Current Process: Ctrl+Alt+F11
Step Into Specific: Shift+Alt+F11
Step Out: Shift+F11
Step Out Current Process: Ctrl+Shift+Alt+F11
Step Over: F10
Step Over Current Process: Ctrl+Alt+F10
Stop Debugging: Shift+F5
Stop Performance Analysis: Shift+Alt+F2
Tasks: Ctrl+Shift+D, K
Threads: Ctrl+Alt+H
Toggle Breakpoint: F9
Toggle Disassembly: Ctrl+F11
Watch1: Ctrl+Alt+W, 1
Watch2: Ctrl+Alt+W, 2
Watch3: Ctrl+Alt+W, 3
Watch4: Ctrl+Alt+W, 4

Debugger Context Menus

Delete: Alt+F9, D
Go To Disassembly: Alt+F9, A
Go To Source Code: Alt+F9, S

Design

Fit All: Ctrl+0
Refresh Page: Ctrl+R
Search CSSPI: Ctrl+Shift+;
Show Handles: F9
Toggle Interactive Mode: Ctrl+Alt+I
Zoom In: Ctrl+Alt+=
Zoom Out: Ctrl+Alt+-

Diff

Ignore Trim Whitespace: Ctrl+\, Ctrl+Space
Inline View: Ctrl+\, Ctrl+1
Left Only View: Ctrl+\, Ctrl+3
Next Difference: F8
Previous Difference: Shift+F8
Right Only View: Ctrl+\, Ctrl+4
Side By Side View: Ctrl+\, Ctrl+2
Switch Between Left And Right: Ctrl+\, Ctrl+Tab
Synchronize View Toggle: Ctrl+\, Ctrl+Down Arrow

Edit

Break Line: Enter
Char Left: Left Arrow
Char Left Extend: Shift+Left Arrow
Char Left Extend Column: Shift+Alt+Left Arrow
Char Right: Right Arrow
Char Right Extend: Shift+Right Arrow
Char Right Extend Column: Shift+Alt+Right Arrow
Char Transpose: Ctrl+T
Clear All: Ctrl+Alt+C
Clear Bookmarks: Ctrl+K, Ctrl+L
Collapse All Outlining: Ctrl+M, Ctrl+A
Collapse Current Region: Ctrl+M, Ctrl+S
Collapse Tag: Ctrl+M, Ctrl+T
Collapseto Definitions: Ctrl+M, Ctrl+O
Comment Selection: Ctrl+K, Ctrl+C
Complete Word: Ctrl+Space; Alt+Right Arrow; Ctrl+K, W; Ctrl+K, Ctrl+W
Copy: Ctrl+C; Ctrl+Ins
Copy Parameter Tip: Ctrl+Shift+Alt+C
Create Copyof Work Item: Shift+Alt+C
Cut: Ctrl+X; Shift+Del
Cycle Clipboard Ring: Ctrl+Shift+V; Ctrl+Shift+Ins
Decrease Filter Level: Alt+,
Delete: Del; Ctrl+Del; Shift+Del
Delete Backwards: Bkspce; Shift+Bkspce
Delete From Model: Shift+Del
Delete Horizontal White Space: Ctrl+K, Ctrl+\
Document End: Ctrl+End; End
Document End Extend: Ctrl+Shift+End; Shift+End
Document Start: Ctrl+Home; Home
Document Start Extend: Ctrl+Shift+Home; Shift+Home
Edit Cell: F2
Expand All Outlining: Ctrl+M, Ctrl+X
Expand Collapse Base Type List: Shift+Alt+B
Expand Current Region: Ctrl+M, Ctrl+E
Find: Ctrl+F
Find All References: Shift+F12
Findin Files: Ctrl+Shift+F
Find Next: F3
Find Next Selected: Ctrl+F3
Find Previous: Shift+F3
Find Previous Selected: Ctrl+Shift+F3
Format Document: Ctrl+K, Ctrl+D
Format Selection: Ctrl+K, Ctrl+F
Go To: Ctrl+G
Goto Brace: Ctrl+]
Goto Brace Extend: Ctrl+Shift+]
Go To Declaration: Ctrl+F12
Go To Definition: F12
Go To Find Combo: Ctrl+D
Go To Next Location: F8
Go To Prev Location: Shift+F8
Hide Selection: Ctrl+M, Ctrl+H
Increase Filter Level: Alt+.
Incremental Search: Ctrl+I
Indent: Shift+Alt+Right Arrow
Insert Snippet: Ctrl+K, Ctrl+X
Insert Tab: Tab
Line Cut: Ctrl+L
Line Delete: Ctrl+Shift+L
Line Down: Down Arrow
Line Down Extend: Shift+Down Arrow; Shift+Up Arrow
Line Down Extend Column: Shift+Alt+Down Arrow
Line End: End
Line End Extend: Shift+End
Line End Extend Column: Shift+Alt+End
Line Open Above: Ctrl+Enter
Line Open Below: Ctrl+Shift+Enter
Line Start: Home
Line Start Extend: Shift+Home
Line Start Extend Column: Shift+Alt+Home
Line Transpose: Shift+Alt+T
Line Up: Up Arrow
Line Up Extend: Shift+Up Arrow; Shift+Down Arrow
Line Up Extend Column: Shift+Alt+Up Arrow
List Members: Ctrl+J; Ctrl+K, L; Ctrl+K, Ctrl+L
Make Lowercase: Ctrl+U
Make Uppercase: Ctrl+Shift+U
Move Control Down: Ctrl+Down Arrow; Down Arrow
Move Control Down Grid: Down Arrow
Move Control Left: Ctrl+Left Arrow; Left Arrow
Move Control Left Grid: Left Arrow
Move Control Right: Ctrl+Right Arrow; Right Arrow
Move Control Right Grid: Right Arrow
Move Control Up: Ctrl+Up Arrow; Up Arrow
Move Control Up Grid: Up Arrow
Move Selected Lines Down: Alt+Down Arrow
Move Selected Lines Up: Alt+Up Arrow
Navigate To: Ctrl+,
Navigate To Lollipop: Shift+Alt+L
New Accelerator: Ins
New String: Ins
Next Bookmark: Ctrl+K, Ctrl+N
Next Bookmark In Folder: Ctrl+Shift+K, Ctrl+Shift+N
Next Highlighted Reference: Ctrl+Shift+Down Arrow
Next Key Typed: Ctrl+W
Open File: Ctrl+Shift+G
Outdent: Shift+Alt+Left Arrow
Overtype Mode: Ins
Page Down: PgDn
Page Down Extend: Shift+PgDn
Page Up: PgUp
Page Up Extend: Shift+PgUp
Parameter Info: Ctrl+Shift+Space; Ctrl+K, P; Ctrl+K, Ctrl+P
Paste: Ctrl+V; Shift+Ins
Paste Parameter Tip: Ctrl+Shift+Alt+P
Peek Backward: Ctrl+Alt+-
Peek Definition: Alt+F12
Peek Forward: Ctrl+Alt+=
Previous Bookmark: Ctrl+K, Ctrl+P
Previous Bookmark In Folder: Ctrl+Shift+K, Ctrl+Shift+P
Previous Highlighted Reference: Ctrl+Shift+Up Arrow
Quick Find Symbol: Shift+Alt+F12
Quick Info: Ctrl+K, Ctrl+I; Ctrl+K, I
Redo: Ctrl+Y; Ctrl+Shift+Z; Shift+Alt+Bkspce
Refresh Remote References: Ctrl+Shift+J
Refresh Work Item: F5
Remove: Del
Removefrom Diagram: Del
Remove Row: Ctrl+Del
Replace: Ctrl+H
Replacein Files: Ctrl+Shift+H
Reverse Incremental Search: Ctrl+Shift+I
Scroll Column Left: Ctrl+Left Arrow
Scroll Column Right: Ctrl+Right Arrow
Scroll Line Down: Ctrl+Down Arrow
Scroll Line Up: Ctrl+Up Arrow
Select All: Ctrl+A
Select Current Word: Ctrl+W
Selection Cancel: Esc
Select Next Control: Tab
Select Previous Control: Shift+Tab
Select To Last Go Back: Ctrl+=
Show Code Lens Menu: Alt+`
Show Tile Grid: Enter
Size Control Down: Ctrl+Shift+Down Arrow; Shift+Down Arrow
Size Control Down Grid: Shift+Down Arrow
Size Control Left: Ctrl+Shift+Left Arrow; Shift+Left Arrow
Size Control Left Grid: Shift+Left Arrow
Size Control Right: Ctrl+Shift+Right Arrow; Shift+Right Arrow
Size Control Right Grid: Shift+Right Arrow
Size Control Up: Ctrl+Shift+Up Arrow; Shift+Up Arrow
Size Control Up Grid: Shift+Up Arrow
Smart Break Line: Shift+Enter
Stop Hiding Current: Ctrl+M, Ctrl+U
Stop Outlining: Ctrl+M, Ctrl+P
Stop Search: Alt+F3, S
Surround With: Ctrl+K, Ctrl+S
Swap Anchor: Ctrl+K, Ctrl+A
Tab Left: Shift+Tab
Toggle All Outlining: Ctrl+M, Ctrl+L
Toggle Bookmark: Ctrl+K, Ctrl+K
Toggle Completion Mode: Ctrl+Alt+Space
Toggle Outlining Expansion: Ctrl+M, Ctrl+M
Toggle Task List Shortcut: Ctrl+K, Ctrl+H
Toggle Word Wrap: Ctrl+E, Ctrl+W
Uncomment Selection: Ctrl+K, Ctrl+U
Undo: Ctrl+Z; Alt+Bkspce
View Bottom: Ctrl+PgDn
View Bottom Extend: Ctrl+Shift+PgDn
View Top: Ctrl+PgUp
View Top Extend: Ctrl+Shift+PgUp
View White Space: Ctrl+R, Ctrl+W
Word Delete To End: Ctrl+Del
Word Delete To Start: Ctrl+Bkspce
Word Next: Ctrl+Right Arrow
Word Next Extend: Ctrl+Shift+Right Arrow
Word Next Extend Column: Ctrl+Shift+Alt+Right Arrow
Word Previous: Ctrl+Left Arrow
Word Previous Extend: Ctrl+Shift+Left Arrow
Word Previous Extend Column: Ctrl+Shift+Alt+Left Arrow
Word Transpose: Ctrl+Shift+T

Editor Context Menus

Add Comment: Ctrl+Shift+K
Breakpoint Editlabels: Alt+F9, L
Breakpoint Settings: Alt+F9, C
Show Item: Ctrl+`
Edit Local File: Ctrl+Shift+P
Execute: Ctrl+Alt+F5
Execute In Interactive: Alt+Enter
Execute Line In Interactive: Alt+'
Go To View: Ctrl+M, Ctrl+G
Toggle Header Code File: Ctrl+K, Ctrl+O
View Call Hierarchy: Ctrl+K, Ctrl+T; Ctrl+K, T

File

Exit: Alt+F4
New File: Ctrl+N
New Project: Ctrl+Shift+N
New Web Site: Shift+Alt+N
Open File: Ctrl+O
Open Project: Ctrl+Shift+O
Open Web Site: Shift+Alt+O
Print: Ctrl+P
Rename: F2
Save All: Ctrl+Shift+S
Save Selected Items: Ctrl+S
Viewin Browser: Ctrl+Shift+W

Format

Align Bottoms: Ctrl+Shift+Down Arrow
Align Centers: Shift+F9
Align Lefts: Ctrl+Shift+Left Arrow
Align Middles: F9
Align Rights: Ctrl+Shift+Right Arrow
Align Tops: Ctrl+Shift+Up Arrow
Bold: Ctrl+B
Button Bottom: Ctrl+B
Button Right: Ctrl+R
Center Horizontal: Ctrl+Shift+F9
Center Vertical: Ctrl+F9
Check Mnemonics: Ctrl+M
Convertto Hyperlink: Ctrl+L
Edit Text: F2
Insert Bookmark: Ctrl+Shift+L
Italic: Ctrl+I
Reset All: Ctrl+Shift+R
Sizeto Content: Shift+F7
Space Across: Alt+Right Arrow; Alt+Left Arrow
Space Down: Alt+Up Arrow; Alt+Down Arrow
Tab Order: Ctrl+D
Test Dialog: Ctrl+T
Toggle Guides: Ctrl+G
Underline: Ctrl+U

Graph View

Bottomto Top: Alt+Up Arrow
Leftto Right: Alt+Right Arrow
Rightto Left: Alt+Left Arrow
Topto Bottom: Alt+Down Arrow

Help

Addand Remove Help Content: Ctrl+Alt+F1
F1 Help: F1
View Help: Ctrl+F1
Window Help: Shift+F1

Image

Airbrush Tool: Ctrl+A
Brush Tool: Ctrl+B
Copyand Outline Selection: Ctrl+Shift+U
Draw Opaque: Ctrl+J
Ellipse Tool: Alt+P
Erase Tool: Ctrl+Shift+I
Filled Ellipse Tool: Ctrl+Shift+Alt+P
Filled Rectangle Tool: Ctrl+Shift+Alt+R
Filled Rounded Rectangle Tool: Ctrl+Shift+Alt+W
Fill Tool: Ctrl+F
Flip Horizontal: Ctrl+H
Flip Vertical: Shift+Alt+H
Larger Brush: Ctrl+=
Line Tool: Ctrl+L
Magnification Tool: Ctrl+M
Magnify: Ctrl+Shift+M
New Image Type: Ins
Next Color: Ctrl+]; Ctrl+Right Arrow
Next Right Color: Ctrl+Shift+]; Ctrl+Shift+Right Arrow
Outlined Ellipse Tool: Shift+Alt+P
Outlined Rectangle Tool: Shift+Alt+R
Outlined Rounded Rectangle Tool: Shift+Alt+W
Pencil Tool: Ctrl+I
Previous Color: Ctrl+[; Ctrl+Left Arrow
Previous Right Color: Ctrl+Shift+[; Ctrl+Shift+Left Arrow
Rectangle Selection Tool: Shift+Alt+S
Rectangle Tool: Alt+R
Rotate90 Degrees: Ctrl+Shift+H
Rounded Rectangle Tool: Alt+W
Show Grid: Ctrl+Alt+S
Show Tile Grid: Ctrl+Shift+Alt+S
Small Brush: Ctrl+.
Smaller Brush: Ctrl+-
Text Tool: Ctrl+T
Use Selectionas Brush: Ctrl+U
Zoom In: Ctrl+Shift+.; Ctrl+Up Arrow
Zoom Out: Ctrl+Shift+,; Ctrl+Down Arrow

Load Test

Jump To Counter Pane: Ctrl+R, Q

Microsoft Azure

Retry Mobile Service Script Operation: Ctrl+Num *, Ctrl+R
Show Mobile Service Script Error Details: Ctrl+Num *, Ctrl+D

Other Context Menus

Refresh Linked Browsers: Ctrl+Alt+Enter
Insert Column: Ins
Column: Ctrl+L
Cancel Interactive Evaluation: Ctrl+Break
Reset Interactive Session: Ctrl+Alt+R
Removefrom Workspace: Del
Go To Controller: Ctrl+M, Ctrl+G
Reload Schemas: Ctrl+Shift+J
Add New Diagram: Ins
Down: Alt+Down Arrow
Down5: Alt+PgDn
To Bottom: Alt+End
To Top: Alt+Home
Up: Alt+Up Arrow
Up5: Alt+PgUp
Rename: Ctrl+R, R
Removefrom Diagram: Shift+Del
Hide Methods Pane: Ctrl+1
Copy Referenceto Clipboard: Ctrl+C
Insert Delay Before: Ctrl+Alt+D
Locate All: Shift+Alt+L
Locatethe UIControl: Ctrl+Shift+L
Movecode: Ctrl+Alt+C
Splitintoanewmethod: Ctrl+Shift+T

Project

Add Content Page: Ctrl+M, Ctrl+C
Add Existing Item: Shift+Alt+A
Add New Item: Ctrl+Shift+A
Class Wizard: Ctrl+Shift+X
Override: Ctrl+Alt+Ins
Previewchanges: Alt+;, Alt+C
Publishselectedfiles: Alt+;, Alt+P
Replaceselectedfilesfromserver: Alt+;, Alt+R

Projectand Solution Context Menus

Move Down: Alt+Down Arrow
Move Up: Alt+Up Arrow

Query Designer

Cancel Retrieving Data: Ctrl+T
Criteria: Ctrl+2
Diagram: Ctrl+1
Execute SQL: Ctrl+R
Goto Row: Ctrl+G
Join Mode: Ctrl+Shift+J
Results: Ctrl+4
SQL: Ctrl+3

Refactor

Encapsulate Field: Ctrl+R, Ctrl+E
Extract Interface: Ctrl+R, Ctrl+I
Extract Method: Ctrl+R, Ctrl+M
Remove Parameters: Ctrl+R, Ctrl+V
Rename: Ctrl+R, Ctrl+R
Reorder Parameters: Ctrl+R, Ctrl+O

Resources

Audio: Ctrl+4
Files: Ctrl+5
Icons: Ctrl+3
Images: Ctrl+2
Other: Ctrl+6
Strings: Ctrl+1

Solution Explorer

Open Files Filter: Ctrl+[, O; Ctrl+[, Ctrl+O
Pending Changes Filter: Ctrl+[, P; Ctrl+[, Ctrl+P
Sync With Active Document: Ctrl+[, S; Ctrl+[, Ctrl+S

SQL

Execute With Debugger: Alt+F5
Expand Wildcards: Ctrl+R, E; Ctrl+R, Ctrl+E
Fullyqualify Names: Ctrl+R, Q; Ctrl+R, Ctrl+Q
Moveto Schema: Ctrl+R, M; Ctrl+R, Ctrl+M
Query Results New Row: Alt+End
Query Results Refresh: Shift+Alt+R
Query Results Stop: Alt+Break
Rename: Ctrl+R, R; F2; Ctrl+R, Ctrl+R
SSDTSchema Compare Compare: Shift+Alt+C
SSDTSchema Compare Generate Script: Shift+Alt+G
SSDTSchema Compare Next Change: Shift+Alt+.
SSDTSchema Compare Previous Change: Shift+Alt+,
SSDTSchema Compare Stop: Alt+Break
SSDTSchema Compare Write Updates: Shift+Alt+U
TSql Editor Cancel Query: Alt+Break
TSql Editor Execute Query: Ctrl+Shift+E
TSql Editor Results As File: Ctrl+D, F
TSql Editor Results As Grid: Ctrl+D, G
TSql Editor Results As Text: Ctrl+D, T
TSql Editor Show Estimated Plan: Ctrl+D, E
TSql Editor Toggle Execution Plan: Ctrl+D, A
TSql Editor Toggle Results Pane: Ctrl+D, R

Table

Columntothe Left: Ctrl+Alt+Left Arrow
Columntothe Right: Ctrl+Alt+Right Arrow
Row Above: Ctrl+Alt+Up Arrow
Row Below: Ctrl+Alt+Down Arrow

Team

Go To Git Active Repositories: Ctrl+0, Ctrl+E; Ctrl+0, E
Go To Git Changes: Ctrl+0, Ctrl+G; Ctrl+0, G
Go To Git Synchronization: Ctrl+0, Ctrl+Y; Ctrl+0, Y
Goto Next Work Item: Shift+Alt+N
Goto Previous Work Item: Shift+Alt+P
New Linked Work Item: Shift+Alt+L
Refresh: F5
Team Explorer Search: Ctrl+'

Team Foundation Context Menus

Tfs Annotate Move Next Region: Alt+PgDn
Tfs Annotate Move Previous Region: Alt+PgUp
Go To Builds: Ctrl+0, Ctrl+B; Ctrl+0, B
Go To Connect: Ctrl+0, Ctrl+C; Ctrl+0, C
Go To Documents: Ctrl+0, Ctrl+D; Ctrl+0, D
Go To Home: Ctrl+0, Ctrl+H; Ctrl+0, H
Go To My Work: Ctrl+0, Ctrl+M; Ctrl+0, M
Go To Pending Changes: Ctrl+0, Ctrl+P; Ctrl+0, P
Go To Reports: Ctrl+0, Ctrl+R; Ctrl+0, R
Go To Settings: Ctrl+0, Ctrl+S; Ctrl+0, S
Go To Team Explorer Navigation: Alt+Home
Go To Team Explorer Next Section Content: Alt+Down Arrow
Go To Team Explorer Page Content: Alt+0
Go To Team Explorer Previous Section Content: Alt+Up Arrow
Go To Team Explorer Section1 Content: Alt+1
Go To Team Explorer Section2 Content: Alt+2
Go To Team Explorer Section3 Content: Alt+3
Go To Team Explorer Section4 Content: Alt+4
Go To Team Explorer Section5 Content: Alt+5
Go To Team Explorer Section6 Content: Alt+6
Go To Team Explorer Section7 Content: Alt+7
Go To Team Explorer Section8 Content: Alt+8
Go To Team Explorer Section9 Content: Alt+9
Go To Web Access: Ctrl+0, Ctrl+A; Ctrl+0, A
Go To Work Items: Ctrl+0, Ctrl+W; Ctrl+0, W
Team Explorer Navigate Backward: Alt+Left Arrow
Team Explorer Navigate Forward: Alt+Right Arrow
Set Focuson Left Window: Alt+1
Set Focuson Result Window: Alt+2
Set Focuson Right Window: Alt+3
Tfs Context My Work Page Create Copy WI: Shift+Alt+C
Tfs Context My Work Page New Linked WI: Shift+Alt+L

Test

Use Coded UITest Builder: Ctrl+\, Ctrl+C
Use Existing Action Recording: Ctrl+\, Ctrl+A

Test Explorer

Debug All Tests: Ctrl+R, Ctrl+A
Debug All Tests In Context: Ctrl+R, Ctrl+T
Open Test: F12
Repeat Last Run: Ctrl+R, L
Run All Tests: Ctrl+R, A
Run All Tests In Context: Ctrl+R, T

Tools

Code Snippets Manager: Ctrl+K, Ctrl+B
Force GC: Ctrl+Shift+Alt+F12, Ctrl+Shift+Alt+F12
Go To Command Line: Ctrl+/

View

All Windows: Shift+Alt+M
NETNonvisual Controls: Ctrl+Shift+N
Backward: Alt+Left Arrow
Bookmark Window: Ctrl+K, Ctrl+W
Browse Next: Ctrl+Shift+1
Browse Previous: Ctrl+Shift+2
Call Hierarchy: Ctrl+Alt+K
Class View: Ctrl+Shift+C
Class View Go To Search Combo: Ctrl+K, Ctrl+V
Code Definition Window: Ctrl+\, D; Ctrl+\, Ctrl+D
Command Window: Ctrl+Alt+A
Data Sources: Shift+Alt+D
Document Outline: Ctrl+Alt+T
Edit Label: F2
Edit Master: Ctrl+M, Ctrl+M
Entity Data Model Browser: Ctrl+1
Entity Data Model Mapping Details: Ctrl+2
Error List: Ctrl+\, E; Ctrl+\, Ctrl+E
F# Interactive: Ctrl+Alt+F
Find Symbol Results: Ctrl+Alt+F12
Forward: Alt+Right Arrow
Forward Browse Context: Ctrl+Shift+7
Full Screen: Shift+Alt+Enter
Navigate Backward: Ctrl+-
Navigate Forward: Ctrl+Shift+-
Next Error: Ctrl+Shift+F12
Next View: Ctrl+PgDn
Notifications: Ctrl+W, N; Ctrl+W, Ctrl+N
Object Browser: Ctrl+Alt+J
Object Browser Go To Search Combo: Ctrl+K, Ctrl+R
Output: Ctrl+Alt+O
Pop Browse Context: Ctrl+Shift+8
Properties Window: F4
Property Pages: Shift+F4
Quick Actions: Ctrl+.
Refresh: F5
Resource View: Ctrl+Shift+E
Server Explorer: Ctrl+Alt+S
Show Smart Tag: Shift+Alt+F10; Ctrl+.
Solution Explorer: Ctrl+Alt+L
SQLServer Object Explorer: Ctrl+\, Ctrl+S
Synchronize Views: Ctrl+Shift+Y
Task List: Ctrl+\, T; Ctrl+\, Ctrl+T
Tfs Team Explorer: Ctrl+\, Ctrl+M
Toolbox: Ctrl+Alt+X
UMLModel Explorer: Ctrl+\, Ctrl+U
View Code: Enter; F7
View Designer: Shift+F7
View Markup: Shift+F7
Web Browser: Ctrl+Alt+R
Zoom In: Ctrl+Shift+.
Zoom Out: Ctrl+Shift+,

Window

Activate Document Window: Esc
Activate Quick Launch: Ctrl+Q
Activate Quick Launch Previous Category: Ctrl+Shift+Q
Activate Solution Explorer Search: Ctrl+;
Activate Window Search: Alt+`
Add Tabto Selection: Ctrl+Shift+Alt+Space
Apply Window Layout1: Ctrl+Alt+1
Apply Window Layout10: Ctrl+Alt+0
Apply Window Layout2: Ctrl+Alt+2
Apply Window Layout3: Ctrl+Alt+3
Apply Window Layout4: Ctrl+Alt+4
Apply Window Layout5: Ctrl+Alt+5
Apply Window Layout6: Ctrl+Alt+6
Apply Window Layout7: Ctrl+Alt+7
Apply Window Layout8: Ctrl+Alt+8
Apply Window Layout9: Ctrl+Alt+9
Close Document Window: Ctrl+F4
Close Tool Window: Shift+Esc
Keep Tab Open: Ctrl+Alt+Home
Moveto Navigation Bar: Ctrl+F2
Next Document Window: Ctrl+F6
Next Document Window Nav: Ctrl+Tab
Next Pane: Alt+F6
Next Split Pane: F6
Next Tab: Ctrl+Alt+PgDn; Ctrl+PgDn
Next Taband Addto Selection: Ctrl+Shift+Alt+PgDn
Next Tool Window Nav: Alt+F7
Previous Document Window: Ctrl+Shift+F6
Previous Document Window Nav: Ctrl+Shift+Tab
Previous Pane: Shift+Alt+F6
Previous Split Pane: Shift+F6
Previous Tab: Ctrl+Alt+PgUp; Ctrl+PgUp
Previous Taband Addto Selection: Ctrl+Shift+Alt+PgUp
Previous Tool Window Nav: Shift+Alt+F7
Show Dock Menu: Alt+-
Show Ez MDIFile List: Ctrl+Alt+Down Arrow
Toggle: Shift+Alt+V

Workflow Designer

Collapse: Ctrl+E, Ctrl+C; Ctrl+E, C
Collapse All: Ctrl+E, Ctrl+Y; Ctrl+E, Y
Connect Nodes: Ctrl+E, Ctrl+F; Ctrl+E, F
Create Variable: Ctrl+E, Ctrl+N; Ctrl+E, N
Expand All: Ctrl+E, Ctrl+X; Ctrl+E, X
Expand In Place: Ctrl+E, Ctrl+E; Ctrl+E, E
Go To Parent: Ctrl+E, Ctrl+P; Ctrl+E, P
Move Focus: Ctrl+E, Ctrl+M; Ctrl+E, M
Navigate Through Designer: Ctrl+Alt+F6
Restore: Ctrl+E, Ctrl+R; Ctrl+E, R
Show Hide Argument Designer: Ctrl+E, Ctrl+A; Ctrl+E, A
Show Hide Imports Designer: Ctrl+E, Ctrl+I; Ctrl+E, I
Show Hide Overview Map: Ctrl+E, Ctrl+O; Ctrl+E, O
Show Hide Variable Designer: Ctrl+E, Ctrl+V; Ctrl+E, V
Toggle Selection: Ctrl+E, Ctrl+S; Ctrl+E, S
Zoom In: Ctrl+Num +
Zoom Out: Ctrl+Num -

XML

Start XSLTDebugging: Alt+F5
Start XSLTWithout Debugging: Ctrl+Alt+F5

Xsd Designer

Show Content Model View: Ctrl+2
Show Graph View: Ctrl+3
Show Start View: Ctrl+1

Remove Unused/Dead Code Using Visual Studio

Many developers don't know about how to remove un-used code and block. Visual Studio giving facility to resolve this.

The following are the rules:

Private methods that are not called from any other code (CA1811)
Unused local variables (CA1804)
Unused private fields (CA1823)
Unused parameters (CA1801)
Internal classes that are not instantiated from any other code (CA1812).

Steps to add code analysis rule

Right click on Project solution > select Property

There you can see code analysis settings

Apply setting as per you requirement.

To know more on Remove Unused/Dead Code Using Visual Studio

Become best developer tips

1. Be Proactive
Things are taking longer than expected
keep everyone happy

2. Practice & make Mistakes
Mistake always teach you new.

3. Self learning from website and books
Self learning always get new in your.

4. Learn from other programmers
Always observer other and pick good points in your.

5. Read Code
Understand code, it will clear you and can make your best.

6. Be the best in your field

7. Involved in Social media, communities and blogs

8. Write a Unit Test

9. Most important of all…Talk to others and have fun
Its good practice to talk code, share and doing white board sessions to brainstorm.

What's New Features in SQL Server 2016

Columnstore Indexes
Database Scoped Configurations
In-Memory OLTP
Query Optimizer
Live Query Statistics
Query Store
Temporal Tables
Striped Backups to Microsoft Azure Blob Storage
File-Snapshot Backups to Microsoft Azure Blob Storage
Managed Backup
TempDB Database
Built-in JSON Support
PolyBase
Stretch Database
Support for UTF-8
New Default Database Size and Autogrow Values

For more info refer https://msdn.microsoft.com/en-us/library/bb510411.aspx

Top Changes in ASP.NET 5 and MVC 6

New flexible and cross-platform runtime
New modular HTTP request pipeline
Cloud-ready environment configuration
Unified programming model that combines MVC, Web API, and Web Pages
Run multiple .NET Framework versions side-by-side
Ability to see changes without re-building the project
Ability to self-host or host on IIS
New tools in Visual Studio 2015, including Grunt, Gulp, Bower, and NPM integration
there is no need to rebuild
it used Roslyn compiler for this.
Debug lambda expression
In .Net 5, you can easily IIS host or self host, your asp.net 2015 project.