SQL Interview Questions and answers on Database Transactions

SQL Interview Questions and answers on Database Transactions

1)What is a database transaction?

Database transaction take database from one consistent state to another. At the end of the transaction the system must be in the prior state if transaction fails or the status of the system should reflect the successful completion if the transaction goes through.

2) What are properties of a transaction? 

Properties of the transaction can be summarized as ACID Properties.

1. Atomicity

A transaction consists of many steps. When all the steps in a transaction gets completed, it will get reflected in DB or if any step fails, all the transactions are rolled back.

2. Consistency

The database will move from one consistent state to another, if the transaction succeeds and remain in the original state, if the transaction fails.

3. Isolation

Every transaction should operate as if it is the only transaction in the system

4. Durability

Once a transaction has completed successfully, the updated rows/records must be available for all other transactions on a permanent basis

SQL Interview Questions and answers on Database Basics

SQL Interview Questions and answers on Database Basics

1. What is DBMS ?

Database management system is a collection of programs that enables user to store, retrieve,update and delete information from a database.

2. What is RDBMS ?

Relational Database Management system (RDBMS) is a database management system (DBMS) that is based on the relational model. Data from relational database can be accessed or reassembled in many different ways without having to reorganize the database tables. Data from relational database can be accessed using a API , Structured Query Language (SQL)

3. What is SQL ?

Structured Query Language(SQL) is a language designed specifically for communicating with databases. SQL is an ANSI (American National Standards Institute) standard .

4. What are the different type of SQL's ?

Frequently asked SQL Interview Questions

1. DDL – Data Definition Language
DDL is used to define the structure that holds the data. For example. table

2. DML– Data Manipulation Language
DML is used for manipulation of the data itself. Typical operations are Insert,Delete,Update and retrieving the data from the table 

3. DCL– Data Control Language 
DCL is used to control the visibility of data like granting database access and set privileges to create table etc.

5. What are the Advantages of SQL

1. SQL is not a proprietary language used by specific database vendors. Almost every major DBMS supports SQL, so learning this one language will enable programmer to interact with any database like ORACLE, SQL ,MYSQL etc.

2. SQL is easy to learn. The statements are all made up of descriptive English words, and there aren't that many of them.

3. SQL is actually a very powerful language and by using its language elements you can perform very complex and sophisticated database operations.

6. what is a field in a database ?

A field is an area within a record reserved for a specific piece of data. 

Examples: Employee Name , Employee ID etc

7. What is a Record in a database ?

A record is the collection of values / fields of a specific entity: i.e. a Employee , Salary etc. 

8. What is a Table in a database ?

A table is a collection of records of a specific type. For example, employee table , salary table etc.

SQL Server 2005 Books Online (November 2008)

SQL Server 2005 Books Online (November 2008)

SQL Server Management Studio Keyboard Shortcuts

SQL Server Management Studio Keyboard Shortcuts

Menu Activation Keyboard Shortcuts

Action	SQL Server 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	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 2014	SQL Server 2008 R2
Refresh	F5	F5
Open a detail window from a grid	ENTER	ENTER

Replication Conflict Viewer Keyboard Shortcuts

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

Query Designer Keyboard Shortcuts

Action	SQL Server 2014	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 2014	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