For Keyboard/keystroke geeks only

OK, so I can’t tell you how fast I type… I have no clue! But – I do know that people get made at me on IM chats because they (well, most of them) cannot keep up (especially my Father!!!)… And the key reason for why??! I tend to stay on the keyboard instead of constantly going for the mouse; I love learning shortcuts/keystrokes, etc. and I like creating them as well… SO – first, did you know that the SQL UE (User Education) Team documented many of the keyboard shortcuts? In the books online click on the small keyboard at the top of the right pane window. It links to “Using the SQL Server Tools, User Interface Reference, Keyboard Shortcuts.”


Second, did you know that you can create your own keyboard keystrokes within Query Analyzer? Check out Tools, Customize. In fact, Alt+F1 already exists (and cannot be changed) as object help. Highlight an object in the QA window and then press Alt+F1 – this will execute sp_help objectname. If you want keyword help (meaning a SQL keyword), highlight the keyword (like SELECT) and press Shift+F1 – this will give you context sensitive books online entry. I typically setup Ctrl+F1 as sp_helpindex (be careful – if you get an extra space in there it won’t work!) and Ctrl+3 as sp_helpconstraint.

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Wow! Wow! Wow! THANK YOU!

I announced my retirement from SQL/tech here and your comments on my blog, on LinkedIn, and on Facebook were overwhelming and humbling! I’m so touched


Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.