SQL Server Management Studio (SSMS) plays important role to connect/manage the database estate without having difficulty, also there are few goodies (hidden gems) that you can simply enable on your Management Studio that will make your day-to-day usage life much better!
Going on the topic of accelerator BOL defines clearly that it allows you to select a menu command or button by pressing ALT+<single letter>. For instance once you have opened SSMS to goto Edit menu, press ALT+E. Similarly you can rearrange and modify toolbar buttons, menus, and menu commands by using the Customize dialog box. Instructions are provided for changing the settings using the mouse and using only the keyboard.
Further customization can be enabled for stored procedures with Ctrl key, it can be created from the Keyboard page of the Tools/Options dialog box. Similarly SSMS offers users two keyboard schemes. By default, it uses the Standard scheme, with keyboard shortcuts based on Visual Studio. Another scheme is used for SQL Server 2000 version, which can closely resembles the tools from SQL Server 2000, in particular the keyboard shortcuts from the Query Analyzer to manage your 2000 version estate. I have seen in few cases where SQL 2005/2008 database has been kept as backward compatibility as 2000 then SQL Server Management Studio cannot offer the keyboard shortcuts from Query Analyzer. So to avoid any disturbance you can change the keyboard scheme or add additional keyboard shortcuts, on the Tools menu, click Options. Select the desired keyboard scheme on the Environment, Keyboard page.
Coming back to Shell based tips, you can easily customize the toolbar through SSMS --> Tools --> Customize or just right-click on toolbar to choose the Customize command. Here is a good tip you need to separate Debug/Stop/Parse buttons towards other end that will reduce any confusion or accidental click to execute a script or SP/View within the SSMS query editor. Not only that if you are totally addicted to old Query Analyzer based icons, then simply take commands like Edit.SelectAll, and Edit.Delete and drag them on to the toolbar to duplicate the old Query Analyzer Erase button. Finally to show the toolbar tips and dynamic help for commands based on keywords the cursor is on use Dynamic Help command (CTRL+ALT+F4 which is standard SSMS 2005 onwards) for SQL 2000 you can use same one.
Take your time to review Books ONline (updated) to go through Keyboard shortcuts for SQL Server Management Studio, that will make your life easier and shortcuts to work efficiency.
Carsten Siemens edited Revision 11. Comment: Added tag: has comment
Carsten Siemens edited Revision 9. Comment: typo fixed
Ed Price MSFT edited Revision 2. Comment: Added "See Also" section.
Nice!