Just got this ad on linked in!

Become an Oracle DBA in 24 Hours... call or mail <SNIP>

Not sure if this link will work for y'all.

http://www.linkedin.com/groups/Become-Oracle-DBA-in-24-42161.S.87682944?view=&gid=42161&type=member&item=87682944&trk=eml-anet_dig-b_nd-pst_ttle-cn

Just got this ad on linked in!

Become an Oracle DBA in 24 Hours... call or mail <SNIP>

Not sure if this link will work for y'all.

http://www.linkedin.com/groups/Become-Oracle-DBA-in-24-42161.S.87682944?view=&gid=42161&type=member&item=87682944&trk=eml-anet_dig-b_nd-pst_ttle-cn

Marco V (1/4/2012)

---

Dave Ballantyne (1/4/2012)

---

Ninja's_RGR'us (1/4/2012)

---

How would this go in anything less than...

My bad, I misunderstood the requirements. The code I gave you is for concatenation.

How many levels deep do you need to go? If it's always 1 then the...

How would this go in anything less than 6 minutes in SSIS?

How would...

That's what you need to understand ;-).

Only 2 options, not too hard to test this out on your own. :hehe:

Ok, so why not just use the order by in SSRS??

CXPACKET is not a real wait, especially not in this query.

If you want to toy with this you can use a few join hints to see the difference (merge &...

In that case yes.

For performance sake I'd pre-distinct the ids so that you don't concatenate n times too many for no reasons.

Something like this :

;

WITH CTE (object_id)

AS

(

SELECT DISTINCT object_id...

Well there's that too! 😀

Datafile + log files = 84 Gb.

Backup only copies non-empty page. But the restore makes a perfect exact copy of the db as it was, including the size.

No way...

No because you need to understand the code to be able to debug it & adjust for more needs.

XML just format as xml (this is where the concatenation happens).

Stuff trims.

Use...

Grant Fritchey (1/4/2012)

---

Statistics might be out of date. A nested loop on 53million rows is pretty frightening. You have full optimization, so the optimizer thinks this is the right way...

Break it down 1 step at a time in your mind. Takes a little work but it's...

For that much data (both in rows and GBs), 8 minutes is not slow by most standards.

The app also has to consume the data so that will slow down the...