On a quick inspection, wouldn't the following avoid the extra sort?

with cteRows

as (

Select col1,

...

Heh. Awesome stuff, going to read that properly in a bit and reply - but I can't help mentioning that window functions can appear in the ORDER BY clause...

On reflection, I still can't make sense of it, but I can demo an outer column reference being used both in the partition by and ntile:

declare @a table (a int...

Hey Dave,

1. integer_expression can only reference columns in the PARTITION BY clause

2. integer_expression cannot reference columns listed in the current FROM clause.

...but the documentation for PARTITION BY value_expression...

Hugo,

I don't disagree with any of that really; as I said before, I think both answers are correct, I just happen to prefer one over the other. My preference...

Impossible to say, at least in my case, since Oracle is NULL. :w00t:

Me either 😉 However, I think there is a subtlety...

Michael Poppers (5/7/2010)

---

Ditto.

Paul, isn't it worth noting the different "ThePrecision" results from the sql_variant_property() output noted earlier in this discussion? Would you like me to add the following code...

Chris Morris-439714 (5/7/2010)

---

The typo is under "Physical Reads". It took ages to find the page 😛

"That analysis also shows that a each physical read was able to load multiple 8KB...

I'm quite surprised no-one has challenged some of the very close results yet because of the issues...

Ah, so you're a 'Tory'! Now the ladies underwear connection makes more sense. 😀

A...

Hey Chris,

I checked with Itzik and he agrees with my analysis, but the reason behind his statement in the article is that he classifies SELECT...INTO under FULL recovery as not...

Hey I watched the BBC coverage on World News all day here (11am - 11pm and still going!)

BTW everyone in the...

Are you suggesting that I should...

Hugo Kornelis (5/7/2010)

---

I would have liked the question (a lot!) if the question had asked for the logical processing order. But the question specificallly asked aboout the sequence internally used,...