If you do an outer join between the source table and the target table, you can insert only the rows that don't already exist.

John

I'm guessing blocking.  Is anything else running on the server when you do this?  Try capturing sys.dm_os_waiting tasks as frequently for lock-related wait types as you can, and see whether...

You can adapt the query on this page to return queries that took more than 20 seconds.  Create a job to run regularly (maybe every five minutes) and...

It should all be taken care of.  If you've got any locations for backups or file exports, for example, that are outside the core folders, then you may need to...

I don't know what you mean by "truncate".  Truncating the transaction log is deprecated and in any case would only be a temporary solution.  Set the database to Simple recovery,...

Either back up the transaction log of msdb regularly, or (preferably) set the database to Simple recovery.  It should then be safe to implement whatever method you use to purge...

Have you tried some of the parameters described here?  INSTALLSHAREDDIR and INSTANCEDIR look as if they may be what you're looking for?

John

Just add a unique constraint on c_id, month and year.  If you've got identity columns throughout your database then you'll want to look at putting a unique constraint on the...

Oh rats - forgot to post the script!

It's my script that will mangle stuff, not yours.  However, it'll do it all in one go instead of using a...

Try this.  Run the query, then copy and paste the results into another query window, inspect, then run.  You may find it mangles "&" or "<" or ">" signs, so...

Are you saying that after you attempt to start SQL Server Agent, no new SQLAGENT.OUT file is created?  How are you changing the service account (through Services or in SSCM?)...

Yes, it's reasonable to expect a query to take longer to run when it runs against larger tables.  Please see this article on how to post performance problems. ...