my 2€ct

- post ddl ! tables and indexes

- remove functions from your predicates if you can (they wil...

there is an issue with using windows-accounts as job-owner.

I don't know the kb-no by heart. I'll add it if I find it back.

If I'm correct it was http://support.microsoft.com/?kbid=233161

profile, profile, profile and don't forget index-tuning-wizard.

There has to be a reason for this latency.

Maybe an other clustering index can help out. Choose it wizely, based upon your usage info.(profiler,...

check smtpmail (http://www.sqldev.net)

BEGIN TRANSACTION           

  DECLARE @JobID BINARY(16) 

  DECLARE @ReturnCode INT   

  SELECT @ReturnCode = 0    

IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1...

So how would you  determine when it's appropriate to run ?

Keep in mind you are preforming an in-transaction-operation.

What you are stating is that with your trigger, all other I/U/D-operations...

oops ... I interpreted "issue" as "error"

The degradation because of plan-recompilation is an "issue" which should not be a problem. The rebuild index should be able...

you can use dos variables to create your directories (one a day) and the move the bak-files to it.

I didn't mention it earlier, but you can have sqlserver managing your...

not that I know of.

Check "rebuilding an index" in BOL.

use backup media.

backup the db using that media (so you always backup to the same physical directory)

in the last step of your backup-job, you can move the backupfiles to the...

you could use a script that launches them all using xp_cmdshell with isql.

e.g. exec xp_cmdshell 'isqlw -E -S myserver -d msdb -i "c:\sqlserver$\scripts\onlyonce_1.sql" -o "c:\sqlserver$\scripts\OutPut_onlyonce_1.sql" '

If you are only moving to new hardware.

Install SQLServer exactly as your original server (drives, directorylocations, ..), bring it to the same servicepack as original.

Now comes the rocket-science: 

can you post the query ? and the ddl of the used object(s) in sqlserver.

noeld is probably right.

If you have a sql2k sp3a and a multiprocessor-box, you need a hotfix for the count(*). That could also be a reason.

replace the distinct by a group by and you'll gain more !

SELECT  Prcs_dte

INTO #A_Dates

FROM tbl_Tracking group by Prcs_dte

SELECT  Prcs_dte

INTO #B_Dates

FROM Acct_Stats group by Prcs_dte

Still I'd suggest you'd profile it and...

sorry for visio

You can reverse-engineer it from within visio.

New DatabaseModelDiagram

database\reverse engineer

(you may have to create and odbc-dsn to get connected)