January 10, 2015 at 11:06 am
Comments posted to this topic are about the item SQL Prompt Tips #5 - Current Statement Execution
January 12, 2015 at 5:07 am
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...
Moreover,
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?"
November 11, 2015 at 8:02 am
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
November 11, 2015 at 8:18 am
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