that's what I assumed.

Normaly, just the statistics will not cause such log-load.

dbreindex rewrites it all. this log-overhead can be reduced by switching to bulk-logged recovery mode.

switch to bluk-logging before performing your maintenance !

full-logged it logs everything !

take a look at BOL : search for "NOCHECK CONSTRAINT"

alter table myschema.mytable NOCHECK CONSTRAINT myconstraint

don't forget to enable it again when you're done.

correct. Only using EM it will not allow you to do so.

I persume because backups should still be available when failed over

(we...

yep, this time I failed to give the wrong answer

same over here. same remark

select t.taskid, t.staffid,

sum(isnull(datediff(s,wt_starttime,isnull(wt_stoptime,getdate()))), 0) as [timespent]

from task t

left join pt_vCheckworktime

on fk_taskid=t.taskid and fk_staffid=t.staffid

group by t.taskid,t.staffid

keep in mind that your udf will be executed at row-level where the join will...

I even didn't get the chance to reply the wrong question , it was already there for me .... You've already answered this...

sorry to fall back in so late ... meeting time

Joining is just a question of good old maths ... sets and subsets.

so, you have full and log-backups up til monday, right ?

You have full or bulk-logged recovery model ?

If you take a new log-backup (incremental), you can restore the full with...

did you enter the fully qualified name in EM ?

'MyW2k3SQL2KServer.theotherdomain.theotherdomainsuffix' ?

add a country-code column to your tables and create a partitioned view.

This way sqlserver may serve you best if you want to avoid dynamic sql.

check BOL

With dynamic sql you might...

have the frist step of your fullbackup doing this :

EXEC MSDB.DBO.sp_update_job @job_name = N'MyserverLog_Incremental', @new_name = N'FullbackupProcedure_Disabled - MyserverLog_Incremental', @enabled = 0

and add a last step doing :

EXEC MSDB.DBO.sp_update_job...

Take a look at Intervention system for runaway jobs 

it needs to be updated for sql2ksp3. But it might get you on track.

- compare execution plans !

How is this one doing  ? (don't like it myself but give it a try  &nbsp