Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Dropping a Row Expand / Collapse
Author
Message
Posted Tuesday, May 10, 2011 9:08 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:57 PM
Points: 33,206, Visits: 15,361
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
Post #1106211
Posted Tuesday, May 10, 2011 10:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 26, 2013 12:06 PM
Points: 7, 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.
Post #1106289
Posted Tuesday, May 10, 2011 11:27 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, June 26, 2014 11:33 AM
Points: 510, Visits: 545
AFAIK none of my SSC blog posts have ever mysteriously "vanished". Once in SQL, forever in SQL


Post #1106395
Posted Tuesday, May 10, 2011 6:06 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:02 PM
Points: 21,657, Visits: 15,326
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1106580
Posted Wednesday, May 11, 2011 7:24 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1106896
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse