January 18, 2011 at 11:24 am
Steve Jones - SSC Editor (1/18/2011)
Well this is a depressing few pages in The Thread.
I could make it worse, but I think maybe I'll decline to
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2011 at 11:41 am
Craig Farrell (1/18/2011)
Oh give me a hoooome, where the indexes roam... and the data, it flows through alll daaaaayyyy...(Wait a second, free range indexes? Isn't that like free range chickens? Kinda paradoxial?)
Please stop, the dogs are barking over here.
January 18, 2011 at 11:53 am
GilaMonster (1/18/2011)
Steve Jones - SSC Editor (1/18/2011)
Well this is a depressing few pages in The Thread.I could make it worse, but I think maybe I'll decline to
Let me guess: News from your "special" project?
January 18, 2011 at 12:03 pm
LutzM (1/18/2011)
GilaMonster (1/18/2011)
Steve Jones - SSC Editor (1/18/2011)
Well this is a depressing few pages in The Thread.I could make it worse, but I think maybe I'll decline to
Let me guess: News from your "special" project?
That project, believe it or not, is in production and I think it might even be getting used (I'll have to check the DB). Got a new one this morning. Nothing major, changes to an existing process. Should be easy.
The business requirements doc is so vague as to be useless (though it takes 12 pages to say nothing). I have to write the functional spec. No one can tell me where or how the current process is implemented. No idea what tables, what database, what application, what anything. The PM (same one I had on the nightmare project) promised the business that he'd tell them tomorrow how long the change would take. He's already drawn up a project plan with 10 days designated for development.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2011 at 12:07 pm
Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great plains in vast flocks, covering the iconic grasses with their flapping feathery bodies to the point where you can't see the landscape?
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
January 18, 2011 at 12:13 pm
OK, to change the subject.
There are three boxes of fruit. One has apples, one oranges, and one has mixed apples/oranges. Each one is labeled, but incorrectly so that the label of each does not match the contents. You can open one box, and select one fruit.
How do you get the labels applied correctly?
January 18, 2011 at 12:13 pm
Alvin Ramard (1/18/2011)
Craig Farrell (1/18/2011)
Steve Jones - SSC Editor (1/18/2011)
Well this is a depressing few pages in The Thread.Anyone got a guitar? We can make a country song out of them!
I'm sure one already exists. 🙂
All you have to do to make yourself happy is play the song backwards! :w00t:
-- Kit
January 18, 2011 at 12:15 pm
jcrawf02 (1/18/2011)
Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great plains in vast flocks, covering the iconic grasses with their flapping feathery bodies to the point where you can't see the landscape?
The legal definition of "free range" means the chickens have access to the outdoors. But that access could be something like "there's a window in the chicken coop."
January 18, 2011 at 12:20 pm
jcrawf02 (1/18/2011)
Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great plains in vast flocks, covering the iconic grasses with their flapping feathery bodies to the point where you can't see the landscape?
Open and grab a fruit from the apple/orange box.
Whatever your pull from this box (apple or orange) is the only fruit in the box otherwise it would have been labeled correctly.
If you get an apple, then the box label apple is the orange box and the box labeled orange is the mix. (the box labeled apple cannot be the mix otherwise the box labeled orange would have been labeled correctly.
Likewise, if you get an orange, then the box label orange is the apple box and the box labeled apple is the mix.
Since my degree in Stats was hammered earlier today, here's a classic:
You are on a game show. There are three doors, behind one of them is a car, behind the other two are goats. You get to pick one of the three doors. After you pick a door, the game show host opens one of the unpicked doors to show you a goat an allows you to switch doors if desired. Should you switch or stick with your original guess? For bonus points, what is the probability of getting the car based on your decision to switch or stay?
Chad
January 18, 2011 at 12:22 pm
Steve Jones - SSC Editor (1/18/2011)
OK, to change the subject.There are three boxes of fruit. One has apples, one oranges, and one has mixed apples/oranges. Each one is labeled, but incorrectly so that the label of each does not match the contents. You can open one box, and select one fruit.
How do you get the labels applied correctly?
Open the box labeled "mixed". As it is mislabeled, whichever fruit you pull out will be the only kind in that box. If you pull out an orange, the box labeled "oranges" must contain apples because all three boxes are mislabeled and thus cannot contiain mixed fruit which would just require switching the two labels. The remaining box contains the mix.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
January 18, 2011 at 12:24 pm
Steve Jones - SSC Editor (1/18/2011)
OK, to change the subject.There are three boxes of fruit. One has apples, one oranges, and one has mixed apples/oranges. Each one is labeled, but incorrectly so that the label of each does not match the contents. You can open one box, and select one fruit.
How do you get the labels applied correctly?
Open the one that is labelled mixed first and pick one fruit. Label that box with the label that matches the fruit you picked. Take the label from the other box and stick it on the box from which you just removed the label. Stick the mixed fruit label on the box that now has no label.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
January 18, 2011 at 12:25 pm
Chad Crawford (1/18/2011)
jcrawf02 (1/18/2011)
Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great plains in vast flocks, covering the iconic grasses with their flapping feathery bodies to the point where you can't see the landscape?Open and grab a fruit from the apple/orange box.
Whatever your pull from this box (apple or orange) is the only fruit in the box otherwise it would have been labeled correctly.
If you get an apple, then the box label apple is the orange box and the box labeled orange is the mix. (the box labeled apple cannot be the mix otherwise the box labeled orange would have been labeled correctly.
Likewise, if you get an orange, then the box label orange is the apple box and the box labeled apple is the mix.
Since my degree in Stats was hammered earlier today, here's a classic:
You are on a game show. There are three doors, behind one of them is a car, behind the other two are goats. You get to pick one of the three doors. After you pick a door, the game show host opens one of the unpicked doors to show you a goat an allows you to switch doors if desired. Should you switch or stick with your original guess? For bonus points, what is the probability of getting the car based on your decision to switch or stay?
Chad
I remember reading this at some point, but can't remember the solution. I believe the best probability is to switch doors, but don't remember why.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
January 18, 2011 at 12:30 pm
Go big or go home. Stick with your pick and take the car or smile and walk away, secure with your decision.
January 18, 2011 at 12:36 pm
There was a man at a restaurant in Paris asking about a dish that contained both rabbit and horse. The more rabbit in it, the better the dish. So he asked the waiter what percentage of the dish was rabbit, and how much horse. The waiter replied, "It's 50% rabbit and 50% horse." But the man, being a statistician, pushed further, "That's 50% of the meat from each?" The waiter says, "That's one rabbit per one horse."
Which goes to show, "Figures don't lie, liars figure."
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking
January 18, 2011 at 12:43 pm
jcrawf02 (1/18/2011)
Not sure I'm following the paradox of the free range chicken. Are you saying it's a paradox because they no longer roam the great plains in vast flocks, covering the iconic grasses with their flapping feathery bodies to the point where you can't see the landscape?
LOL, yeah, that too. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 15 posts - 23,281 through 23,295 (of 66,751 total)
You must be logged in to reply to this topic. Login to reply