Hi Howard,

yes, it works just like you described

update STG

Set TuoteKEY = D.TuoteKEY

From dbo.STG_KIINTIO_VK_vDW STG JOIN DW.dbo.D_TUOTE D ON (STG.TuoteKoodi=D.TuoteKoodi)

Where VUOSI = 2004 and VIIKKO >= 1 and VIIKKO = 6...

Hi,

sounds reasonable. I'll just start a test loop and see how the log file behaves

thanks, ville

Hello Howard.

still wondering that when does the server have time to clear the log when I run the loop with 170 million rows. It is one batch/transaction, isn't it?...

Hi,

I'm on vacation but briefly. Yes, It makes very much sence what you say... but do I need to add explicite 'Begin Tran - Commit Tran' when running it in...

jep, works fine, thanks

Hi

No it's running o Simple recovery model. But I could still use a loop construct and expand it a little to cover years 2004-2008 and just execute DBCC shrinkfile.... after...

There is still about 15 million rows when split like in my example.

OK, thanks. I'll just continue like I planned, or maybe I need to split even more

Ville

Yes you are right (you still need to format it) but like I said earlier that is not the point here... but the bug in sql2000 (sp3) that ruined the outcome...

Hi,

yes, that was the case. I'm sorry, I didn't look for similar cases in the kbase.

I added 1 sec and 2 secs to the UDF parameters when calling it and... it...

Hi,

yes, my solution is not fast since UDF's are not fast i've noticed. That is not the point here though, I just used my UDF here to quickly scan the...

Hi,

I think I found the reason. There was a message in the DTS logs that stated some key error and that the log could not be written. Path not found....

Hi Dirk,

please let me know should you find out something interesting

Regards,  Ville

Hi,

I started this thread a year+ ago and funny as it sounds, almost at the same time that I started to get notifications to my email about replies to this topic,...

Jep,

that's it! Thank you

V

Thanks,

I haven't noticed that one, it works.

The setting