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?...

Always happy to provide free beer for the esteemed denizens of SSC. ...

Ha! Has it been chilly in H€ll recently then?

On a serious note,...

Chris Morris-439714 (3/2/2010)

---

Hey Paul, guilty as charged. It's going to be thursday evening before I can give the article the time it deserves. Reading it on the train into work...

So I see.

Without the ORDER BY, SQL Server is free to return the TOP (N) rows in any order it thinks makes most...

Thanks Jason. I think it's pretty much ready for publication now, just waiting for the last couple of reviews to come in (hint hint).

Try telling that to:

Thierry Henry or Maradonna

Paul

RBarryYoung (3/1/2010)

---

In fact every plan posted so far thinks there's only 66 rows in that table (instead of the 15020 that it actually finds). I really would like to...

Thanks for the feedback!

Decimal places and rounding considerations scare me. I freely admit to being a total amateur with that sort of thing.

Last thing about that...

One difficulty with this is that it ROLLBACKs all open transactions, not just the one started here.

The correct approach is to ROLLBACK to...

Ah yes, I...

Some love / interest, but I am not much of a fan of football. It helps that NZ...

agustingarzon (3/1/2010)

---

The exec plan for your suggestion is the same as NewExec I just posted. The approach is ok, but it's making a clust-ix-scan that scans through the first...

GabyYYZ (3/1/2010)

---

One option, especially if you have an indexed identity column on your source table, is to generate a separate table of random row numbers, create a clustered index on...

Not a clustered Primary Key, I trust?