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)

use " NOT EXISTS " ... that's the way to do it !

speed it up by adding an index on table/view Acct_Stats column prcs_dte.

just m 2ct:

select  book, count(distinct page) as pagecount

from tl10_land

group by book

this can be don without unavailability :

check dbcc shrinkfile / shrinkdb in BOL

take special notice at Shrinking the Transaction Log.

You know SQLmail and clustering is not supported.

That's why I use smtp-mail on my clustered sqlservers.

SQLmail works, but only for a while, then it...

If it stays in rollback-state to long according to your expectation, you may need to stop and start your sqlserver-instance.

(I've had to do this frequently because some of my users...

Maybe you can get on the road with this :

(its a script I use to gather backup-job-info)

-- alzdba dd 08/01/2004

-- request Backup-job info

set nocount on

-- check BOL

select substring(case server...

I was thinking it should be something like that.

Did I overlook that documentation ?

Where/how did you...