RBarryYoung (3/2/2010)

---

But in most of these plans, there is NO predicate on the Scan. How can it stop execution/scanning if it has no predicate? And the Actuals bear...

[font="Verdana"]Detersiveness[/font]

QB = QuarterBack! Easy 😉

Off to Google Saturday Night Live Da Bears. Hoping for a YouTube link.

Heh. "Did you guys order the Nachos or the beers?"

And I would (genuinely) guess at Chicago. But why ask about the Bears?

It's a meme isn't it. I was never any good at memes.

CirquedeSQLeil (3/2/2010)

---

Chris Morris-439714 (3/2/2010)

---

Not really. It's this one which got me thinking about it, because the data looks very familiar and also because the OP doesn't appear to know what...

That is moderately irritating, yes.

Ok, so I think I get the dog-pile thing, but Bears???

Reminds me of a Superman film!

I sense a dog-pile* coming on.

---

* Did I use that phrase correctly?

Chris Morris-439714 (3/2/2010)

---

Is it just me, or are the posters who appear to be the students, the ones who have the nerve to post their homework here, the worst offenders...

No worries, I'm relieved you see...

Yes, 30% is the hard-coded guess. There's loads more information here:

http://msdn.microsoft.com/en-us/library/dd535534.aspx

edit:

Specifically, it's the selectivity of the Filter operator that implements the "WHERE num.IXX > 15000" condition in the queries....

Barry,

Are you asking about the Row Goal thing I said I'd have a look for? I didn't look yet :blush:

But it really is just a case of guesswork by...

Chris Morris-439714 (3/2/2010)

---

You're welcome. This one's a cracker too. Do you mind if I pass it to a colleague here? And if that is ok with you, what are the...

Chris Morris-439714 (3/2/2010)

---

Sure thing, an article on CROSS APPLY would be perfick, send it over. Is this the APPLY that has an automagical cardinality alignment effect or the regular one?...