read up on inner joins, sum, group by, order by and top

Right now the only idea I have in an insert/update trigger.

Depending on how often you error out on that 300 limit would make me decide wether to use an instead...

That's why sps exist!

GilaMonster (9/22/2011)

---

EXEC TotalChangeOfSubject

SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/

Chapter 8: "The how and why of Page Restores", Grant...

Thanks for the DDL, we still (and mostly) need to see the ACTUAL execution plan.

TIA.

This is one of the main reason I...

Stefan Krzywicki (9/23/2011)

---

Ninja's_RGR'us (9/23/2011)

---

yes remove the USE 😀

Then the join with sys.indexes won't work. I've never had the need for it, but I'm sure there's a way around...

Grant Fritchey (9/23/2011)

---

Based on a long history of reading about...

Yup, the best improvement I've seen is like 24 hours to 10 seconds, maybe even faster.

So I think 1 more round of tuning might prove interesting ;-).

yes remove the USE 😀

Then the join with sys.indexes won't work. I've never had the need for it, but I'm sure there's a way around it with the...

montyismobile (9/23/2011)

---

Hi Gianluca Sartori,

I would like to thank you for all your help with this cursor issue. When tested against the same data set your query produced identical results...

SQLRNNR (9/23/2011)

---

Ninja's_RGR'us (9/23/2011)

---

SQLRNNR (9/23/2011)

---

Good thing NFL players don't work for...

Ya in compat 80 you can't use a function as a parameter for another function.

Compat mode change the way tsql behaves. The "ironic" twist here is that if you...

SQLRNNR (9/23/2011)

---

Good thing NFL players don't work for Amazon. ...

+1, but I still didn't get the report on the schema diffs between now at 2-3 weeks ago when it began.

SOMETHING changed.