Thank You Jeff ... now back to my paper and pencil ...

ftp sounds great but it is not secure. The user ID and password are sent over the wire in clear text !!! Do a bit more homework and possibly spend...

As a cleanup activity you might want to check the default database of the first userid that was executing the JOB. You may have some table cleanup in that database...

What about unchecking Auto Updating Statistics for the database in question ...

I agree with Jeff and a great many other in the posting. I definitely have seen very 'few' worth their salt. It is not the people, it is the curriculum - more...

All of the banter here has shown the multiple methods of solving a SQL problem. I for one have learned no matter what the initial impetus of the post.

We are Borg, We have adapted ...

CTRL-A, CTRL-C, CTRL-V are now automatic keystrokes when replying to any post !

Are you restricting the 'import' by batchsize ? If not then you should probably look into a 'batchsize' of around 100,000 rows. If you do not do this then the...

You should still be careful though ... dropping an index can have rather SEVERE performance impacts if it is one used frequently. Just imagine all of the lookups, index seeks, etc...

The process is already syncronous and serial .. step 1 executes and conditionally then step 2 executes.

What is the real issue or problem that you are having ?

(oh, I'd also...

Granted this is a late response (I'm about 2 weeks behind in SSC newsletters) ...

My point is that since 1988 every position that I have held I have been subject...

I dunno for sure but I believe that you can have a 2005 MSX and a 2000 TSX but not the reverse as you are trying.

One step was possibly missing and some refinements:

 use master

 go

 exec sp_addlogin @loginame='THE_LOGINAME', @passwd='A_very_Secure_Password', @defdb='THE_DATABASE_NAME'

 exec THE_DATABASE_NAME..sp_adduser @loginame='THE_LOGINAME'

 exec THE_DATABASE_NAME..sp_addrolemember @rolename='db_datareader', @membername='THE_LOGINAME'

 go

 checkpoint

 go

Talk to the folks at TUSC (http://www.tusc.com) they provide training to Oracle themselves and are partners. I've taken the Admin and Perf Tuning classes. My training was in Chicago,...

Good question. But architecturally speaking, a SQL server should always have a minimum of 2 CPUs.