Previously on Tweak your SQL Server Management Studio…
Today in Tip #3 I want to quickly cover something I use all the time, not just in SSMS. Keyboard Shortcuts!
It drives me crazy to watch people hit the start button, go to all programs, scroll to the folder, find the application, and then click it… Seriously people… Windows Key (on the keyboard), and start typing the name! Want to open SSMS? Windows Key + type SSMS and you’re done!
Ok, I get it… It drives my wife nuts when I’m just hitting ctl+keys to make the computer do things, but whatever, it’s faster!!!
You can get the same thing in SSMS. Some are so easy, like F5 to run the query. I actually don’t like this one, running the query should be harder! I’ve accidentally F5’d when trying to hit the #5 so many times, that I’ve actually removed the F5 Execute, and just use CTL+E instead. FWIW CTL+E already works, if you’d prefer that one. Here are some pics on how to remove the F5 Execute and how to add it back.
So back on topic! Query Shortcuts. There are soooooo many queries that we run daily / weekly, etc, that you should start to really look into query shortcuts.
Right about the same place as the other tips I’ve discussed, Tools > Options > Keyboard > Query Shortcuts you’ll find a really simple UI to set up custom shortcuts to the queries you run the most. You can of course create your own Stored Procs and fire those off from here too.
Alright, that’s it for short cuts. There are loads of them out there, what do you find to be the most useful? Are you going to use this for your environment going forward? Let me know!