SQL Prompt Tips #5 - Current Statement Execution

  • Comments posted to this topic are about the item SQL Prompt Tips #5 - Current Statement Execution

  • Nothing can prevent you to run a wrong statement, if you are not careful when you work...

    For me the easiest way to prevent any issue, it is still the same, you need to use Transactions...


    if you install SSMSBoost, you will not be able to run an update/delete statement without receiving a pop up windows saying:

    "UPDATE/DELETE statement without WHERE clause

    Are you sure you want to continue query execution?"

  • Transactions on a multi-user system can cause issues when people forget to commit or rollback before they get up to get a cup of coffee.

    Whatever works to make you more engaged and careful is helpful

    412-977-3526 call/text

  • Nothing prevents you from making mistakes.

    Pop ups work sometimes, but people get muscle memory and will learn where the dialog will appear, and where the OK/Yes button is and start to click automatically.

    Transactions work, but people will open them, look at data and forget sometimes that they're blocking others.

    good habits are really important, and ones that we always follow.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply