- What statement are you using ?

did you test using :

BULK INSERT mydb.myschema.myobject

from '\\UNC_path\myobjectdata.txt'

WITH

( FIELDTERMINATOR = ''

--,CODEPAGE = 'raw'

...

- you need to keep in mind it takes +- 30 seconds to fail over a sql instance.

- Applications will have to reconnect.

- Let's hope your applications can cope with...

maybe 😉

We schedule index rebuilds on most of our server on a weekly basis.

(during low usage hours)

On some servers it is scheduled every day because we are not allowed

to change...

- can you provide some sqlserver version info ? (+ sp + cu )

- how much memory is available for sqlserver ?

- did you set a min or max memory...

check out the nice art :http://www.sqlservercentral.com/columnists/chawkins/dedupingdatainsqlserver2005.asp

with sql2005 you nee to enable xp_cmdshell !

This is not advized !

You'd be better off by shifting this action to a sqlagent job,

and run that job with a proxy...

how about using the dts.events.FireError in your script ?

Keep in mind you 'll also need to enable the "FailPackageOnFailure" property.

you may want to set the deadlockpriority for your job to low:

SET DEADLOCKPRIORITY LOW

So if a job is canceled, it will be yours.

Best is to start a trace (sql...

You need the same space volume as the original MDF, ndf and LDF files !

If they were allocated e.g. mdf 50Gb and ldf 10G , even if you only have...

This is concerning SQL2005 right ?

You may want to check on these new join methodes:

EXCEPT and INTERSECT

http://msdn2.microsoft.com/en-us/library/ms188055.aspx

Hi Andy,

Thank you for the script.

It's this kind of "simple" scripts that make this site such a great resource !

Can you post it in the contribution center ?

If I'm correct there is a SSMS setting that is used 'show system objects'

For the moment I don't have SSMS available, but I guess BOL will have a ref for...

You can also find very valuable input in this thread

http://www.sqlservercentral.com/Forums/FindPost453679.aspx

I've just used it for testing purposes to get a feeling with as well CLR as

geocoding.

I didn't compare the various providers.

Maybe others did or are using it in...

All race pilots must know the gobbledegook to direct their technicians to

figure out the solution to...