Try running that on a 1M rows table then tell us how long it takes to run... assuming your query is done before xmas!!!

Have you actually looked at books online to see what might be causing all those errors... no offense but a simple F1 hit could get you almost all those answers...

My bad about the reorg / reindex thing, I was thinking about another script... this scripts runs in about 2H15 every night... the first time I used it, the log...

Not really, but it doesn't matter since any one can use google to find this thread again, so any new info is still usefull to post!

I think you can do that... here's something you can try and test out for yourself (and let us know if it works).

Create a new filegroup.

Move the table to that...

Looks like I can bid higher... so I'll move my rates up to 175$ / hour,do the maths for me : That'll be cheaper that way!

I've had weirder requests than this... sometimes the user wants the data if and only if a certain amount of days has been taken into account.

But I agree... that looks...

Great I'll be the first to put a bid on this... 80 hours @ 95$ / hour >>> that'll be 7600$ to check up on this. Plus whatever flight,...

Yup that's the one!

Thanks for the clarifications!

I meant this by quirky update :

Update table set @var = UpdatedColumn = @var + WhateverIttakesToEvalutateThisVariable

This must be used with a index hint on a temp table to be...

Hugo, are you talking about the quirky update for 2000?

and I third :P.

I second!

That doesn't make a whole lot of sens to me... if rand or newid() is called only once in the query, then how come the result is really random... and...

Try reinstalling the application... or see if you have a place where you can setup the server info (server name, login,, password, database, etc).

Maybe there's some info that needs to...