Thanks but I was trying to avoid SORT tasks for obvious reasons.

I have actually managed to get it bottomed out. In the end I used an XSLT transformation to 'flatten'...

Thanks for the prompt reply Gail.

Even bigger thanks for the undocumented Command. That has helped identify the table and index that are at the root of the problem. Now to...

And remove your colleague's rights to DROP TABLE:exclamationmark:

sqlbuddy123 (1/10/2011)

---

MAX Degree of Parallelism is not recommended for OLTP Systems until and unless there are some very specific requirements. It cause 100% CPU utilization peaks for very short periods...

3 poor weeks in a row is one too many. Overall PowerPivotPro probably deserved to go through so I have no complaints. Managed to get my Brit team into the...

I've squeaked into the playoffs and been paired with PowerPivotPro. I think my previous win counts for nothing and neither team finished the season strongly. If either team can have...

Talk about crawling over the line and into the playoffs, gonna have to up my game if I want to beat PPP again 😀

Grant/PaulB/Steve,

Thanks for your replies.

Is open Write access on a Production Box a little generous or am I just...

He He, Replies like buses (in the UK anyway)

Wait 4 years then 3 come at once :w00t:

Just don't expect such a generous game...

Wondered how long it would take? 😛

I got...

Ray K (12/2/2010)

---

SQLDCH (12/2/2010)

---

Left Outer Join (9-3) vs British Bulldogs (7-5) -- the Brits are battlin' for the playoffs, LOJ wants top spot

Texas Engineers (2-10) vs Orange Engineers (5-7) --...

Wow, I just looked at the schedule to finish the season. Based on the way teams have performed this season, I don't think anyone could have picked a harder run...

No,...