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»»

Pascals Triangle, Home Work and Root Cause Analysis Expand / Collapse
Author
Message
Posted Wednesday, October 19, 2011 12:14 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 2,959, Visits: 1,947
Comments posted to this topic are about the item Pascals Triangle, Home Work and Root Cause Analysis

LinkedIn Profile
Newbie on www.simple-talk.com
Post #1192655
Posted Wednesday, October 19, 2011 2:06 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 14, 2015 8:40 AM
Points: 1,428, Visits: 818
Excellent article.

Even better, I see you used to work in Manchester!


Paul.
Manchester,UK.
Post #1192689
Posted Wednesday, October 19, 2011 7:18 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 28, 2015 8:23 PM
Points: 1,626, Visits: 1,895
I enjoyed your article because it was relevant on multiple levels. Thank you for a well-written article!
Post #1192835
Posted Wednesday, October 19, 2011 7:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 14, 2015 12:03 PM
Points: 6, Visits: 276
Hi David,

This is fantastic! I can find many uses for this..


Thanks!


John R
Post #1192853
Posted Wednesday, October 19, 2011 8:10 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, May 22, 2015 8:44 PM
Points: 1,479, Visits: 1,922
Good article.

Of course, the point you omitted is how the actual probability of any given failure alters the calculations.

With the lottery example, because each of the numbers is (supposedly) equally likely to be chosen, Pascal's triangle is a perfect model, and shows the true (im)probability of winning.

With the car example, QA testing ensures that parts generally have a much higher probability of working than failing, thus although there's only one way for the whole system to work perfectly, it's more likely than the millions of ways it can fail.
Post #1192869
Posted Wednesday, October 19, 2011 9:50 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 2,959, Visits: 1,947
Yes, and apparently each space shuttle launch expected at least 6000 components to fail but was still designed to work.

On my list of things not to think about is precisely how fast a piece of metal moves inside a motor-bike engine when it's between your legs


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1192977
Posted Wednesday, October 19, 2011 12:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 2,959, Visits: 1,947
Joe, I should have remembered that. I think one of your books mentioned storing a calendar table rather than trying to workout calendar maths on the fly.

It is so easy to forget that storing a few thousand records for utility sets costs next to nothing but delivers one hell of a lot of utility


LinkedIn Profile
Newbie on www.simple-talk.com
Post #1193120
Posted Wednesday, October 19, 2011 1:34 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 11:18 AM
Points: 10, Visits: 51
Thanks for the great article. It reminds me of why when I used to fly airplanes my instructor kept telling me that the probability of an engine failure in a twin engine plane was twice as high as a single... of course you still had one engine running in a twin.

do it right, or do it over and over, it's up to you
Post #1193190
Posted Wednesday, October 19, 2011 3:10 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 16, 2015 4:10 AM
Points: 59, Visits: 424
Don't you also need to make sure that @n <> @r so you don't divide by 0? And @r <> 0 either.
Post #1193255
Posted Wednesday, October 19, 2011 3:16 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, April 16, 2015 4:10 AM
Points: 59, Visits: 424
CELKO - your code does not compile. Looks like some logic is missing in the case statement.

I don't get " SELECT fact FROM Factrorials WHERE @f = @n " I @f supposed to be a column or a variable?

I like the idea of it and the recommendation of storing calendar data in table.
Post #1193262
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse