SQL in Sixty Seconds is indeed tremendous fun to do. Every week, we try to come up with some new learning which we can share in Sixty Seconds. In this busy world, we all have sixty seconds to learn something new – no matter how much busy we are. In this episode of the series, we talk about another interesting feature of SQL Server Management Studio. In SQL Server Management Studio (SSMS) we have two button side by side. 1) Execute (!) and 2) Debug (>). It is quite confusing to a few developers. The debug button which looks like a play button encourages developers to click on the same thinking it will execute the code. Also developer with a Visual Studio background often click it because of their habit. However, Debug button is not the same as Execute button. In most of the cases developers want to click on Execute to run the query but by mistake they click on Debug and it wastes their valuable time.
It is very easy to fix this. If developers are not frequently using a debug feature in SQL Server they should hide it from the toolbar itself. This will reduce the chances to incorrectly click on the debug button greatly as well save lots of time for developer as invoking debug processes and turning it off takes a few extra moments.
In this Sixty second video we will discuss how one can hide the debug button and avoid confusion regarding execution button. I personally use function key F5 to execute the T-SQL code so I do not face this problem that often.
[youtube=http://www.youtube.com/watch?v=3KkX9WFcTkk]
More on Removing Debug Button in SSMS:
- SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS)
- SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video
- SQL SERVER – Discard Results After Query Execution – SSMS
- SQL SERVER – Tricks to Comment T-SQL in SSMS – SQL in Sixty Seconds #019 – Video
- SQL SERVER – Right Aligning Numerics in SQL Server Management Studio (SSMS)
I encourage you to submit your ideas for SQL in Sixty Seconds. We will try to accommodate as many as we can.
If we like your idea we promise to share with you educational material.
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
5 Comments. Leave new
Ugh, I click that damn debug button every once and a while and then there goes 30+ seconds and I’ve lost my flow… doh! the thought never crossed my mind to just remove it..
Great tip, thanks for sharing!! :-)
Great tip. That was annoying the hell out of me. Thanks!
Can you show “how to use Debug button” (i.e. how to debug in SSMS) in next SQL in Sixty Seconds video?
I would also see how this is used. I have a developer who wants to use this on a remote server but can’t seem to get it working despite being in local sysadmin groups for SQL and Windows.