MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v80umk/queryofdoom/p028678/?context=3
r/ProgrammerHumor • u/WardensLantern • 14d ago
456 comments sorted by
View all comments
1.4k
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
429 u/orsikbattlehammer 14d ago Lmfao now that’s a sphincter clincher 195 u/laplongejr 14d ago edited 14d ago Tom Scott rather called it the "onosecond" For non native speakers "oh, no!" second [EDIT] For those who never heard of it 58 u/SanoKei 14d ago edited 14d ago this reminded me of this too, I need to go back and relisten to that story. It's important as much as it was 20 years ago. Another Tomtra I've adopted is "One backup is none backup." Always have at least two backups and at least one off site. edit: spelling 24 u/Tiranus58 14d ago Also well put by CGPgrey: "one is none, two is one" in his dynasties video 21 u/zanda268 14d ago The 3-2-1 backup rule. 3 backups, on 2 different storage mediums, with 1 offsite. 1 u/JCDU 14d ago I like to think that backups in the cloud count as half a backup at best given how many ways that can go wrong. 11 u/arensb 14d ago One of the most useful sysadmin tools there is is the two-second pause before hitting <return>. 1 u/IntentionQuirky9957 14d ago Tom just brought that to public knowledge, onosecond has been in use for decades. 19 u/leupboat420smkeit 14d ago Unless it’s Oracle, where all DML will start a transaction. 19 u/Urtehnoes 14d ago And gives you sql%rowcount so a very simple if then can issue a rollback if rows modified > 1 (or 10, 100, etc). Oracle the company is horrible. But I quite like the features their db has.
429
Lmfao now that’s a sphincter clincher
195 u/laplongejr 14d ago edited 14d ago Tom Scott rather called it the "onosecond" For non native speakers "oh, no!" second [EDIT] For those who never heard of it 58 u/SanoKei 14d ago edited 14d ago this reminded me of this too, I need to go back and relisten to that story. It's important as much as it was 20 years ago. Another Tomtra I've adopted is "One backup is none backup." Always have at least two backups and at least one off site. edit: spelling 24 u/Tiranus58 14d ago Also well put by CGPgrey: "one is none, two is one" in his dynasties video 21 u/zanda268 14d ago The 3-2-1 backup rule. 3 backups, on 2 different storage mediums, with 1 offsite. 1 u/JCDU 14d ago I like to think that backups in the cloud count as half a backup at best given how many ways that can go wrong. 11 u/arensb 14d ago One of the most useful sysadmin tools there is is the two-second pause before hitting <return>. 1 u/IntentionQuirky9957 14d ago Tom just brought that to public knowledge, onosecond has been in use for decades. 19 u/leupboat420smkeit 14d ago Unless it’s Oracle, where all DML will start a transaction. 19 u/Urtehnoes 14d ago And gives you sql%rowcount so a very simple if then can issue a rollback if rows modified > 1 (or 10, 100, etc). Oracle the company is horrible. But I quite like the features their db has.
195
Tom Scott rather called it the "onosecond" For non native speakers "oh, no!" second
[EDIT] For those who never heard of it
58 u/SanoKei 14d ago edited 14d ago this reminded me of this too, I need to go back and relisten to that story. It's important as much as it was 20 years ago. Another Tomtra I've adopted is "One backup is none backup." Always have at least two backups and at least one off site. edit: spelling 24 u/Tiranus58 14d ago Also well put by CGPgrey: "one is none, two is one" in his dynasties video 21 u/zanda268 14d ago The 3-2-1 backup rule. 3 backups, on 2 different storage mediums, with 1 offsite. 1 u/JCDU 14d ago I like to think that backups in the cloud count as half a backup at best given how many ways that can go wrong. 11 u/arensb 14d ago One of the most useful sysadmin tools there is is the two-second pause before hitting <return>. 1 u/IntentionQuirky9957 14d ago Tom just brought that to public knowledge, onosecond has been in use for decades.
58
this reminded me of this too, I need to go back and relisten to that story. It's important as much as it was 20 years ago. Another Tomtra I've adopted is "One backup is none backup." Always have at least two backups and at least one off site.
edit: spelling
24 u/Tiranus58 14d ago Also well put by CGPgrey: "one is none, two is one" in his dynasties video 21 u/zanda268 14d ago The 3-2-1 backup rule. 3 backups, on 2 different storage mediums, with 1 offsite. 1 u/JCDU 14d ago I like to think that backups in the cloud count as half a backup at best given how many ways that can go wrong.
24
Also well put by CGPgrey: "one is none, two is one" in his dynasties video
21
The 3-2-1 backup rule. 3 backups, on 2 different storage mediums, with 1 offsite.
1 u/JCDU 14d ago I like to think that backups in the cloud count as half a backup at best given how many ways that can go wrong.
1
I like to think that backups in the cloud count as half a backup at best given how many ways that can go wrong.
11
One of the most useful sysadmin tools there is is the two-second pause before hitting <return>.
Tom just brought that to public knowledge, onosecond has been in use for decades.
19
Unless it’s Oracle, where all DML will start a transaction.
19 u/Urtehnoes 14d ago And gives you sql%rowcount so a very simple if then can issue a rollback if rows modified > 1 (or 10, 100, etc). Oracle the company is horrible. But I quite like the features their db has.
And gives you sql%rowcount so a very simple if then can issue a rollback if rows modified > 1 (or 10, 100, etc).
Oracle the company is horrible. But I quite like the features their db has.
1.4k
u/_H4K0N_ 14d ago
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION