June 30, 2008 at 5:39 am
GSquared, SSCrazy,
There is no need for me to carry this Post any further. The reason for this is because your last suggestion was the solution I was looking for.
For over 3 years our nightly ETL process we run to load our Datawarehouse used to take 3:45 to 4 hours. Never less than 3 hours and 45 minutes.
Your new query, which by the way has been "pushed" into Production, now makes our ETL job run in just under an hour.
You are amazing. Truly amazing.
With no data that returned any rows you still managed to come up with a query that runs in 2 seconds.
I take my hat off to you and bow to you.
Thank you so very much for taking the time you dedicated to this POST.
June 30, 2008 at 8:54 am
You're very welcome. Glad I could help. It was fun digging into this one. 🙂
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 46 through 46 (of 46 total)
You must be logged in to reply to this topic. Login to reply