SQL Server Management Studio Keyboard Shortcuts

It can be a bit of a pain when writing long SQL statements when you want to check a table for data. Some people write the full 'Select' statement, some use the side bar, I use a keyboard shortcut to execute a Select statement really quickly.

Creating a keyboard shortcut in Management Studio
In SQL Server Management Studio > Tools > Options
Open the keyboard tree view on the left side and select query shortcuts
Use any of the available slots for the keyboard shortcut 'Select * From'. The below example uses Ctrl+3.

SQL Server Management Studio Keyboard Shortcut Options

The default shortcuts included in Management Studio are really useful when developing as they give vital information about tables but limit the typing and clicking required to get to that information.