May 19, 2025 at 12:00 am
Comments posted to this topic are about the item Helpful Management Studio Settings and Features
May 19, 2025 at 4:50 pm
Some great tips here, I use a bunch of these regularly!
One thing I think you should call out though: Alt+F1 is actually the default Query shortcut (Options -> Environment -> Keyboard -> Query Shortcuts) for executing "sp_help" against whatever text is highlighted. The result is exactly as you described, but it's easy to create other shortcuts for stored procedures to streamline SSMS, and it also has defaults for sp_who (Ctrl+1) and sp_lock (Ctrl+2) as well. I don't find either of those nearly as useful as sp_help, but I do like to create shortcuts for Adam Machanic's sp_whoisactive and some of Brent Ozar's sp_blitz procedures, and I'm sure other DBA's and developers will have their go-to procedures as well.
SSMS Options can be confusing for new users, but there's lots of useful settings in there like the ones in this article!
May 20, 2025 at 7:00 am
Thanks for this great posts; I found some really useful tips! Of course I could have found out a lot myself, but (probably like most users) I never got around to examining those options. Your tips are practical (so useful), thanks for letting us benefit from your experience
May 20, 2025 at 5:16 pm
This was such a great article. I did not know about many of these tips. I often find the text in the options dialog box to be too abbreviated to describe what the option actually does. What's super frustrating is that the help button in the upper corner of the dialog box takes me to a page that does nothing to explain the options. You gave enough information in your article above for us to understand what the option does so each of us could decide if that option would be helpful for ourself or not.
I really appreciate you sharing your favorite customizations and tips.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply