SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Dropping a Row


Dropping a Row

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)SSC Guru (146K reputation)

Group: Administrators
Points: 146553 Visits: 19432
cfradenburg (5/10/2011)
Eric M Russell (5/10/2011)
I'm not sure how many users monitor their guest book or blog posts close enough on a daily basis to notice if one (out of a couple hundred) entries from months back suddenly disappeared. I'm sure somebody eventually would, and they'd be really verklempt about it.


If it was an old one then chances are very slim that anyone would notice. I was coming from the perspective that it was the write failing meaning it is a new post instead of an old one. If it's a read that fails and it shows up after a refresh no one is going to care if it's Facebook or a blog. Well, no one should care. If it were a medical record, one bad read can have very, very bad consequences even if the data shows up on a refresh.


The issue is with some systems (not saying Facebook is one), that you might write an update on Node 1, and you see the update. However Node 1 is buried, and before it can update node 2 and node 3, it fails. when it's rebuilt/recovered. your update is gone. You might not notice, or if you do, do you stop using the service? You might, but depending on your investment in the service, you might not. You might be more careful, or chalk it up to a random glitch in the matrix.

However if one of my deposits failed at an ATM because it wasn't fully hardened in the entire system, that's bad.

Customers don't want to ever lose their data, but it happens and we accept some minor glitches.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Donald Bustell
Donald Bustell
SSC Journeyman
SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)SSC Journeyman (77 reputation)

Group: General Forum Members
Points: 77 Visits: 41
My takeaway from that talk was not that it was a failure of algorithmic learning but rather it is an algorithm designed to predict my interests or point of view; the problem being that I will no longer see points of view not aligned with my own, thereby creating a "mind-narrowing" experience.
Randy Rabin
Randy Rabin
SSChasing Mays
SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)SSChasing Mays (626 reputation)

Group: General Forum Members
Points: 626 Visits: 561
AFAIK none of my SSC blog posts have ever mysteriously "vanished". Once in SQL, forever in SQL :-)



SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)SSC Guru (66K reputation)

Group: General Forum Members
Points: 66669 Visits: 18570
jay holovacs (5/10/2011)
It falls into the 'right tool for the right job'



I tend to agree



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

GSquared
GSquared
SSC Guru
SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)SSC Guru (57K reputation)

Group: General Forum Members
Points: 57795 Visits: 9730
cfradenburg (5/10/2011)
Eric M Russell (5/10/2011)
I'm not sure how many users monitor their guest book or blog posts close enough on a daily basis to notice if one (out of a couple hundred) entries from months back suddenly disappeared. I'm sure somebody eventually would, and they'd be really verklempt about it.


If it was an old one then chances are very slim that anyone would notice. I was coming from the perspective that it was the write failing meaning it is a new post instead of an old one. If it's a read that fails and it shows up after a refresh no one is going to care if it's Facebook or a blog. Well, no one should care. If it were a medical record, one bad read can have very, very bad consequences even if the data shows up on a refresh.


It would depend on the data that was lost.

If we're talking blogs, for example, there are entries on some that I reference pretty regularly, even though they are far from recent. For example, just yesterday, I had four devs read an older article on Gail Shaw's blog. If that entry disappeared, it would be noticed, and it would matter.

How about if older movies started disappearing from IMDB?

So, it depends on the data. I guess the point is, if your social site of choice is using a non-ACID data repository, don't put any data into it that would matter if it suddenly goes away. "Matter" is always subjective, so pick your fights on that one.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search