Can you list exactly what is in the connection dialog?

Gail,

where was that from? It's interesting, and worth a little writing. I certainly have felt that way sometimes. Someone pinged me this weekend with an "urgent" thread. I replied that...

It's a self join, using the left outer join, to get one version of the table, and a second version of the table matching up the IDs, but off by...

that's annoying. I hope people don't answer them, and that was what I was worried with the #sqlhelp tag.

I do surface some interesting discussions on Twitter, but try not to...

Nebraska gets that great College World Series. Need to pop over some year and see it.

Excellent, thanks for the update and glad something is working for you.

I tend to agree with Paul. I think users, or non-qualified people setting up DB servers get into trouble. If It is too busy, they ought to have a document...

And once again, I'm lost.

You need how many CPUs you need. Depends on load, and the performance you need from them.

I'm not 100% sure of all the places where ftp returns 1, but I think a "quit" or a "remote closed" will not force an error. I think only of...

You can shut down the services for the two unneeded instances in the Control Panel | Servers, and set their startup to "manual".

The problem is that ftp opens its own shell. It allows you to re-enter the password (or user), when the connection fails.

You might look at using the SSIS tasks...

There are rollforward messages in there, if they were large transactions, they could have caused some disk activity.

It seems like most people want a segregated section. That's not a bad idea, and I'll kick it around with the publishing team here.

I do like to run articles...

Check the default trace for that time. See what might have been running.

SQL will use all resources if they are needed, so I'd start by trying to determine what might...