Are the posted questions getting worse?
-
dwain.c (4/21/2014)
Greg Edwards-268690 (4/21/2014)
TomThomson (4/20/2014)
Greg Edwards-268690 (4/20/2014)
Bucket List Challenge - teach Jim to Filet a fish properly.I'll keep trying, but I may fail miserably.
Fillet "a fish" is not a good test. I can fillet brown trout, dover sole, lemon sole, sea trout, see bass, hake, lythe, saithe, and salmon (and a few other NE Atlantic and Mediterranean fish whose English names I dont know) because they are worth filleting. I can also fillet rainbow trout, but most Americans and Canadians who know me think I can't because my method of filleting it doesn't separate any bits (I just chuck the whole fish in the rubbish bin). I haven't a clue how to fillet the sort of stuff that you guys catch (well, maybe my rainbow trout treatment would be appropriate, but maybe not) but I don't think that detracts from my dba abilities, because actually, I have no dba abilites to detract from - I'm totally aganst this over-specialisation thing that invented dbas - but I have to admit I'm probably overspecialised when it comes to fish filleting.
If I could teach Jim to filet a fish properly, like I could teach him to do anything.
Ever have someone "I've got it", then blazes ahead doing exactly what you've said not to do?
Mike and I filet, so Jim and Anatoly can have some fish to eat.
Never have gotten Anatoly to wield a knife, so I feel we have a second challenge available.
Buy a man a fish and he can feed his family for a day.
Teach a man to fish and he can feed his family forever.
Teach a man to fillet a fish and he can still only feed his family for a day.
From the look of Dwain's fish and considering the type of fish they have in that part of the world, he might feed the family for more than a day.
-
Ed Wagner (4/22/2014)
dwain.c (4/21/2014)
Greg Edwards-268690 (4/21/2014)
TomThomson (4/20/2014)
Greg Edwards-268690 (4/20/2014)
Bucket List Challenge - teach Jim to Filet a fish properly.I'll keep trying, but I may fail miserably.
Fillet "a fish" is not a good test. I can fillet brown trout, dover sole, lemon sole, sea trout, see bass, hake, lythe, saithe, and salmon (and a few other NE Atlantic and Mediterranean fish whose English names I dont know) because they are worth filleting. I can also fillet rainbow trout, but most Americans and Canadians who know me think I can't because my method of filleting it doesn't separate any bits (I just chuck the whole fish in the rubbish bin). I haven't a clue how to fillet the sort of stuff that you guys catch (well, maybe my rainbow trout treatment would be appropriate, but maybe not) but I don't think that detracts from my dba abilities, because actually, I have no dba abilites to detract from - I'm totally aganst this over-specialisation thing that invented dbas - but I have to admit I'm probably overspecialised when it comes to fish filleting.
If I could teach Jim to filet a fish properly, like I could teach him to do anything.
Ever have someone "I've got it", then blazes ahead doing exactly what you've said not to do?
Mike and I filet, so Jim and Anatoly can have some fish to eat.
Never have gotten Anatoly to wield a knife, so I feel we have a second challenge available.
Buy a man a fish and he can feed his family for a day.
Teach a man to fish and he can feed his family forever.
Teach a man to fillet a fish and he can still only feed his family for a day.
From the look of Dwain's fish and considering the type of fish they have in that part of the world, he might feed the family for more than a day.
Jim might make it only a small family, given some luck.
Part of the odd filet count when Jim helps might just be due to it is hard to determine what to keep.
Boneless would eliminate everything, and something with meat is just about as scarce.
I will post an update after Mike and I have had a couple more attempts to teach the skill again this summer.
Glad that we usually catch plenty of fish, so it's not horrible to lose a few for practice.
-
Brandie Tarvin (4/22/2014)
*THAT* is a filleted fish?Ummm, would you take it the wrong way if I begged you to keep your day job and forget about opening that restaurant? @=)
I said Jim was a challenge.
At least you can see it once was a fish.
For some reason, I'd bet he didn't get A's in biology for dissecting a frog.
-
Greg Edwards-268690 (4/22/2014)
Ed Wagner (4/22/2014)
dwain.c (4/21/2014)
Greg Edwards-268690 (4/21/2014)
TomThomson (4/20/2014)
Greg Edwards-268690 (4/20/2014)
Bucket List Challenge - teach Jim to Filet a fish properly.I'll keep trying, but I may fail miserably.
Fillet "a fish" is not a good test. I can fillet brown trout, dover sole, lemon sole, sea trout, see bass, hake, lythe, saithe, and salmon (and a few other NE Atlantic and Mediterranean fish whose English names I dont know) because they are worth filleting. I can also fillet rainbow trout, but most Americans and Canadians who know me think I can't because my method of filleting it doesn't separate any bits (I just chuck the whole fish in the rubbish bin). I haven't a clue how to fillet the sort of stuff that you guys catch (well, maybe my rainbow trout treatment would be appropriate, but maybe not) but I don't think that detracts from my dba abilities, because actually, I have no dba abilites to detract from - I'm totally aganst this over-specialisation thing that invented dbas - but I have to admit I'm probably overspecialised when it comes to fish filleting.
If I could teach Jim to filet a fish properly, like I could teach him to do anything.
Ever have someone "I've got it", then blazes ahead doing exactly what you've said not to do?
Mike and I filet, so Jim and Anatoly can have some fish to eat.
Never have gotten Anatoly to wield a knife, so I feel we have a second challenge available.
Buy a man a fish and he can feed his family for a day.
Teach a man to fish and he can feed his family forever.
Teach a man to fillet a fish and he can still only feed his family for a day.
From the look of Dwain's fish and considering the type of fish they have in that part of the world, he might feed the family for more than a day.
Jim might make it only a small family, given some luck.
Part of the odd filet count when Jim helps might just be due to it is hard to determine what to keep.
Boneless would eliminate everything, and something with meat is just about as scarce.
I will post an update after Mike and I have had a couple more attempts to teach the skill again this summer.
Glad that we usually catch plenty of fish, so it's not horrible to lose a few for practice.
I can't believe I'm reading this - here, of all places 😀
One of many skills my father patiently taught when I was old enough to know that if I did it really badly I might get out of it as a chore. When the fish you've just caught is your best bet for the next meal or three, you soon learn how not to waste it and also how to cut so that it doesn't fall to bits during cooking. The same technique - the slow, accurate one, not the quick commercial one - works on every single fish I've ever had the pleasure of eating.
Does anyone around here know anything about output lists from index seek operators, by any chance? Don't all raise your hands at once, you might drop your rod...
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
paul.knibbs (4/22/2014)
Are you sure he used a knife and not a shotgun? 🙂That was a very sharp knife.
Bones, fins - hardly anything slows this man down. 😀
-
jasona.work (4/22/2014)
The carnage!!That looks like he was trying to practice his Norman Bates / Jason Voorhees routine...
:hehe:
Now you've got me scared.
Not sure if he knows the difference between me and the fish if I hand him one.
Amazing factoid - never have seen him cut himself. 😀
-
ChrisM@Work (4/22/2014)
Does anyone around here know anything about output lists from index seek operators, by any chance? Don't all raise your hands at once, you might drop your rod...What are you "seeking" to know? (and I'm not an expert, but I'm sure I have a w.a.g. or three).
-
Greg Edwards-268690 (4/22/2014)
jasona.work (4/22/2014)
The carnage!!That looks like he was trying to practice his Norman Bates / Jason Voorhees routine...
:hehe:
Now you've got me scared.
Not sure if he knows the difference between me and the fish if I hand him one.
Amazing factoid - never have seen him cut himself. 😀
#
Looking at that picture, I'd put some distance between you and the fish if you ever hand him one. Have you ever seen him cut other people though?
On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a PhilosopherHow to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
-
ChrisM@Work (4/22/2014)
Greg Edwards-268690 (4/22/2014)
Ed Wagner (4/22/2014)
dwain.c (4/21/2014)
Greg Edwards-268690 (4/21/2014)
TomThomson (4/20/2014)
Greg Edwards-268690 (4/20/2014)
Bucket List Challenge - teach Jim to Filet a fish properly.I'll keep trying, but I may fail miserably.
Fillet "a fish" is not a good test. I can fillet brown trout, dover sole, lemon sole, sea trout, see bass, hake, lythe, saithe, and salmon (and a few other NE Atlantic and Mediterranean fish whose English names I dont know) because they are worth filleting. I can also fillet rainbow trout, but most Americans and Canadians who know me think I can't because my method of filleting it doesn't separate any bits (I just chuck the whole fish in the rubbish bin). I haven't a clue how to fillet the sort of stuff that you guys catch (well, maybe my rainbow trout treatment would be appropriate, but maybe not) but I don't think that detracts from my dba abilities, because actually, I have no dba abilites to detract from - I'm totally aganst this over-specialisation thing that invented dbas - but I have to admit I'm probably overspecialised when it comes to fish filleting.
If I could teach Jim to filet a fish properly, like I could teach him to do anything.
Ever have someone "I've got it", then blazes ahead doing exactly what you've said not to do?
Mike and I filet, so Jim and Anatoly can have some fish to eat.
Never have gotten Anatoly to wield a knife, so I feel we have a second challenge available.
Buy a man a fish and he can feed his family for a day.
Teach a man to fish and he can feed his family forever.
Teach a man to fillet a fish and he can still only feed his family for a day.
From the look of Dwain's fish and considering the type of fish they have in that part of the world, he might feed the family for more than a day.
Jim might make it only a small family, given some luck.
Part of the odd filet count when Jim helps might just be due to it is hard to determine what to keep.
Boneless would eliminate everything, and something with meat is just about as scarce.
I will post an update after Mike and I have had a couple more attempts to teach the skill again this summer.
Glad that we usually catch plenty of fish, so it's not horrible to lose a few for practice.
I can't believe I'm reading this - here, of all places 😀
One of many skills my father patiently taught when I was old enough to know that if I did it really badly I might get out of it as a chore. When the fish you've just caught is your best bet for the next meal or three, you soon learn how not to waste it and also how to cut so that it doesn't fall to bits during cooking. The same technique - the slow, accurate one, not the quick commercial one - works on every single fish I've ever had the pleasure of eating.
Does anyone around here know anything about output lists from index seek operators, by any chance? Don't all raise your hands at once, you might drop your rod...
Slow Down? Get it right, the speed will come?
Might have to UTube this sometime, and you can see what Mike and I are doing wrong.
Maybe Jim can't hear?
My rod just fell in the lake - that was a mean trick. 😀
-
Steve Jones - SSC Editor (4/17/2014)
rodjkidd (4/17/2014)
Greg Edwards-268690 (4/16/2014)
WayneS (4/16/2014)
Steve Jones - SSC Editor (4/16/2014)
OK, now I'll be keeping a better eye on y'all. For the first time in like 3 years I have no trips scheduled and no speaking commitments in the future.😀
See what starting SQLSaturday did to you?
Always nice to get a break from the chaos.
We'll be easy on you. 😀
I'll give you two weeks Steve!
Rodders...
Ha! surgery next week and then I'm out of any flights for a month no matter what. Sad that I have to skip TechEd after I was selected to speak :(.
Steve,
Two words - web cam
Sorry to hear you got picked for TechEd 😀 You know what I mean 😉
Rodders...
-
BWFC (4/22/2014)
Greg Edwards-268690 (4/22/2014)
jasona.work (4/22/2014)
The carnage!!That looks like he was trying to practice his Norman Bates / Jason Voorhees routine...
:hehe:
Now you've got me scared.
Not sure if he knows the difference between me and the fish if I hand him one.
Amazing factoid - never have seen him cut himself. 😀
#
Looking at that picture, I'd put some distance between you and the fish if you ever hand him one. Have you ever seen him cut other people though?
No, but I don't want to become the first.
Maybe a diversion....
-
ChrisM@Work (4/22/2014)
Does anyone around here know anything about output lists from index seek operators, by any chance?Maybe, what do you want to know?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
Brandie Tarvin (4/22/2014)
ChrisM@Work (4/22/2014)
Does anyone around here know anything about output lists from index seek operators, by any chance? Don't all raise your hands at once, you might drop your rod...What are you "seeking" to know? (and I'm not an expert, but I'm sure I have a w.a.g. or three).
Thank you very much for stepping up, Brandie - I'm quite out of ideas and more than happy to read w.a.g's or anything else for that matter. The question I'm asking is here - http://www.sqlservercentral.com/Forums/FindPost1563832.aspx and the query, to save you a few moments, is this:
select KeyInstn, MAX(dateendedstandard) DateEndedStandardfrom ObjectViews..InternalOperCBGEstimate
where dateendedstandard < @Current
and mostrecentsequence = 1
and UpdOperation<2
group by KeyInstn
I've set up a test table here which relies on one of our real tables, if you like I could set up a test table generator to give you something to code against.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
GilaMonster (4/22/2014)
ChrisM@Work (4/22/2014)
Does anyone around here know anything about output lists from index seek operators, by any chance?Maybe, what do you want to know?
See above, Gail. You'll remember the thread from last week.
“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail ShawFor fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden -
ChrisM@Work (4/22/2014)
The question I'm asking is here - http://www.sqlservercentral.com/Forums/FindPost1563832.aspx and the query, to save you a few moments, is this:
select KeyInstn, MAX(dateendedstandard) DateEndedStandardfrom ObjectViews..InternalOperCBGEstimate
where dateendedstandard < @Current
and mostrecentsequence = 1
and UpdOperation<2
group by KeyInstn
I've set up a test table here which relies on one of our real tables, if you like I could set up a test table generator to give you something to code against.
First thing to note is that the query mentions ObjectViews..InternalOperCBGEstimate, but according to the plan, the table name is [InternalUseOnly_New].[dbo].[OperatorCBGEstimate]. I suspect ObjectViews..InternalOperCBGEstimate is actually a view (from the name of the DB)
So the columns which come out of the index seek are:
KeyInstn and DateEndedStandard. I can't see anywhere the other columns you mentioned, looking at the plan in the post you quoted there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass
Viewing 15 posts - 43,756 through 43,770 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply