If I can get away in time to drive up to Memphis for Alvin's SSIS presentation, I promise...

I loved the comic, although to be honest I won't quit visiting SSC because its gone. I'd like to see it continued.

But Ninja's_RGR'us has a good...

Hey Jack,

Where did you and I have dinner last year? As I recall, it was close to the convention center.

Bob

To say "yes" would be an insult to plaid goats everywhere. 😉

I'm ready to take my beating now, Mr. Jones.

I have seen Grant (and Steve) in kilts. 'Tis na a pretty sight.

Jeff, you really have to let me buy you a drink at the PASS summit.

I agree. A good covering index is the key to getting this type of query to run quickly. How often are these totals requested? ...

GIMME COOKIE !!!

There are two types of people in the world. Those who can see what's coming next.

Especially since you could ruin a lot of monitors by throwing pork chops through them.

That presupposes I had an edge to begin with.

Maybe I just regained my sense of shame...:unsure:

I wouldn't mind having an option to let the optimizer run longer to find a "best" execution plan, as long as the result was cached and became usable by later...

Too bad, there's no way to know exactly what is going on without referring to the execution plans.

Have a good weekend.

Could you please post up the execution plans from both your queries?

Offhand, I'll speculate that by moving the WHERE clause and using it to filter the Order table in the...

CREATE TABLE dbo.SAMPLE (data XML)

😀

Much blowing of vuvuzelas ensues.....