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 «««4,3754,3764,3774,3784,379»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, April 22, 2014 6:46 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 675, Visits: 6,815
jasona.work (4/22/2014)
The carnage!!

That looks like he was trying to practice his Norman Bates / Jason Voorhees routine...



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.
Post #1563820
Posted Tuesday, April 22, 2014 6:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, November 21, 2014 12:12 PM
Points: 5,615, Visits: 6,413
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).


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1563822
Posted Tuesday, April 22, 2014 6:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:46 AM
Points: 1,182, Visits: 3,881
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...



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 Philosopher

How to post a question to get the most help
Post #1563823
Posted Tuesday, April 22, 2014 6:56 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 675, Visits: 6,815
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.
Post #1563827
Posted Tuesday, April 22, 2014 6:57 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:32 AM
Points: 2,858, Visits: 5,843
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...



Post #1563828
Posted Tuesday, April 22, 2014 7:00 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 1:54 PM
Points: 675, Visits: 6,815
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...



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....
Post #1563830
Posted Tuesday, April 22, 2014 7:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:04 AM
Points: 40,432, Visits: 36,884
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1563833
Posted Tuesday, April 22, 2014 7:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 6,869, Visits: 14,179
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) DateEndedStandard 
from 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 Shaw

For 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
Exploring Recursive CTEs by Example Dwain Camps
Post #1563834
Posted Tuesday, April 22, 2014 7:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 6,869, Visits: 14,179
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 Shaw

For 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
Exploring Recursive CTEs by Example Dwain Camps
Post #1563835
Posted Tuesday, April 22, 2014 7:21 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:04 AM
Points: 40,432, Visits: 36,884
ChrisM@Work (4/22/2014)
[quote][b]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) DateEndedStandard 
from 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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass



  Post Attachments 
2014-04-22 15-20-04.jpg (204 views, 198.04 KB)
Post #1563840
« Prev Topic | Next Topic »

Add to briefcase «««4,3754,3764,3774,3784,379»»»

Permissions Expand / Collapse