It's just saying that the PersonEmail column has a different collation from the Person Name column.  Use a COLLATE clause on one of them to match it to the collation...

That second screenshot only shows that a.cust_po exists, not b.cust_po.

John

The only thing I can think of is that, despite the proxy account, the file enumeration is being performed in the context of the SQL Server Agent account.  Might be...

I agree with Thom.  However, given that you have comedy limited values in your column(s), you're already in a bit of a pickle.  If you absolutely have to do this,...

Willem

Still a little too vague, really.  If you're always replacing the same character with the same other character (S with R), use REPLACE.  If you're always changing the...

I assume that changing the stored procedure is an option?  If so, get rid of the @idSubsytem parameter and put an INSERT INTO Subsystem DEFAULT VALUES statement (I'm doing this...

If I've understood correctly, all you need to do is to INSERT DEFAULT VALUES into subsystem and use an OUTPUT clause to get the ID, which you can use in...

No, that's nothing to do with it.  .BAK is just a convention: you can give the file any extension you like and it will still work.  This really does point...

No, you should still be able to run RESTORE HEADERONLY even if the backup is from a newer version.  In any case, I'd be surprised if your app could do...

I always wince when I see stuff inserted into a staging table, only to be immediately deleted.  It's usually more efficient not to insert it in the first place.  Try...

You could set up an Extended Events session and capture oledb_provider_initialized.  Presumably there are similar events for other providers, in case any of your linked servers don't use OLDEB.

John

Alex

Might be worth changing the block size to 64KB from its default of 4KB.  Also, speak to your SAN administrator about whether putting log files on...

From those numbers, it looks as if most of your waits are to do with disk latency, with a little bit of blocking (possibly caused by the disk latency) thrown...