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,3774,3784,3794,3804,381»»»

Are the posted questions getting worse? Expand / Collapse
Author
Message
Posted Tuesday, April 22, 2014 12:52 PM


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 @ 2:22 PM
Points: 42,443, Visits: 35,497
ChrisM@Work (4/22/2014)
GilaMonster (4/22/2014)
ChrisM@Work (4/22/2014)
And yes, every other plan the OP posted show only KeyInstn and DateEndedStandard coming out of the index seek, as you'd expect.
Systems here won't let me anywhere his table and index defs, so I don't know the definition of index [AI_OperatorCBGEstimate_HAP].


Might have something to do with the columns being needed for predicate, not seek predicate. Maybe filter operation folded into index seek or something similar.

None of the other plans show anything like this behaviour
I'm beginning to think the OP changed the query in the .sqlplan file.


Very possible. Don't feel like reloading the plan, but maybe check down the operators where (if) the columns disappear.



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 #1563993
Posted Tuesday, April 22, 2014 12:52 PM


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 @ 2:22 PM
Points: 42,443, Visits: 35,497
Lynn Pettis (4/22/2014)
ChrisM@Work (4/22/2014)
GilaMonster (4/22/2014)
ChrisM@Work (4/22/2014)
And yes, every other plan the OP posted show only KeyInstn and DateEndedStandard coming out of the index seek, as you'd expect.
Systems here won't let me anywhere his table and index defs, so I don't know the definition of index [AI_OperatorCBGEstimate_HAP].


Might have something to do with the columns being needed for predicate, not seek predicate. Maybe filter operation folded into index seek or something similar.

None of the other plans show anything like this behaviour
I'm beginning to think the OP changed the query in the .sqlplan file.


Possible considering how much trouble he goes to trying to obfuscate everything before posting. He goes so far as things don't always match up between the query(queries) and the DDL he provides.


It's not that OP.



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 #1563994
Posted Tuesday, April 22, 2014 2:12 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:10 AM
Points: 1,211, Visits: 6,541
Brandie Tarvin (4/22/2014)
Jeff Moden (4/22/2014)
ChrisM@Work (4/22/2014)

The easiest method I've seen was shown to me by a prawn fisherman in Ullapool and I've only tried it with herring but it would probably work with other similar-sized oily fish like mackerel. Put the fish belly-down on a hard flat surface and thump it along the back so that it just deforms and no more. Pick it up, pinch off the head, then slip your thumb from the head end of the cavity along the backbone on both sides, feeling your way and separating the flesh from the bone. It takes about 15 seconds at a guess but you don't want to be wearing your best cashmere sweater when you do it.


Dammit! I guess I'm going to have to sue that guy for process patent infringement... that's the same process I use on developers that don't follow company coding standards.


Jeff, may I have permission to use your patented Dev Treatment here at my workplace? @=)


Note to self -
Filet - A - Dev is not something you want to experience.
Always follow company standards.
Post #1564023
Posted Tuesday, April 22, 2014 2:34 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:03 AM
Points: 7,019, Visits: 12,912
Greg Edwards-268690 (4/22/2014)
...
Note to self -
Filet - A - Dev is not something you want to experience.
Always follow company standards.


Why not? It'll be a once-in-a-lifetime experience




Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1564032
Posted Tuesday, April 22, 2014 11:17 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 11:31 AM
Points: 36,728, Visits: 31,180
Brandie Tarvin (4/22/2014)
Jeff Moden (4/22/2014)
ChrisM@Work (4/22/2014)

The easiest method I've seen was shown to me by a prawn fisherman in Ullapool and I've only tried it with herring but it would probably work with other similar-sized oily fish like mackerel. Put the fish belly-down on a hard flat surface and thump it along the back so that it just deforms and no more. Pick it up, pinch off the head, then slip your thumb from the head end of the cavity along the backbone on both sides, feeling your way and separating the flesh from the bone. It takes about 15 seconds at a guess but you don't want to be wearing your best cashmere sweater when you do it.


Dammit! I guess I'm going to have to sue that guy for process patent infringement... that's the same process I use on developers that don't follow company coding standards.


Jeff, may I have permission to use your patented Dev Treatment here at my workplace? @=)


You have to master the 3 banded Pork Chop launcher first.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1564091
Posted Wednesday, April 23, 2014 5:30 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 9:30 AM
Points: 325, Visits: 3,196
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.
Will buy a stupid hat.


I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Post #1564211
Posted Wednesday, April 23, 2014 9:04 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 2:28 PM
Points: 33,062, Visits: 15,174
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.


Yes and no. As a DBA, I've tried to be proactive and look for ways to prevent issues. I've also tried to make sure I'm insurance as much as possible for the production side.

I guess I'm insurance in the dev side, being proactive with better code to prevent issues. Like alarms, devices or process changes mandated by insurance companies.

However most of the time I'm insurance, which means I am paid to solve problems when a claim is filed.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1564332
Posted Wednesday, April 23, 2014 9:26 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 2,949, Visits: 5,222
Any of the Threadizens going to SQL Saturday in Chicago this weekend?

I'm over for some more SQL Skills training, so thought I might as well attend.

Looks as though a couple of people from my "bucket list" of SQL peeps are there presenting so that's good.

Cheers,

Rodders...



Post #1564338
Posted Wednesday, April 23, 2014 10:30 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 15,517, Visits: 27,896
rodjkidd (4/23/2014)
Any of the Threadizens going to SQL Saturday in Chicago this weekend?

I'm over for some more SQL Skills training, so thought I might as well attend.

Looks as though a couple of people from my "bucket list" of SQL peeps are there presenting so that's good.

Cheers,

Rodders...


Yep. I'll be there and doing a SQL in the City Seminar on Friday before the event.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1564376
Posted Wednesday, April 23, 2014 10:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:56 PM
Points: 2,949, Visits: 5,222
Grant Fritchey (4/23/2014)
rodjkidd (4/23/2014)
Any of the Threadizens going to SQL Saturday in Chicago this weekend?

I'm over for some more SQL Skills training, so thought I might as well attend.

Looks as though a couple of people from my "bucket list" of SQL peeps are there presenting so that's good.

Cheers,

Rodders...


Yep. I'll be there and doing a SQL in the City Seminar on Friday before the event.


Grant, Yeah but I've met you before, so you don't count!
Only joking it will be good to catch up in person. I saw you were presenting.

Rodders...



Post #1564382
« Prev Topic | Next Topic »

Add to briefcase «««4,3774,3784,3794,3804,381»»»

Permissions Expand / Collapse