I don't know about round trips, but you what you often want to reduce is selecting a million rows from a remote server, bring it to the client, or another...

Very nice article. Short, simple, useful. A few typos help me think about what I'm doing, so I won't complain about those!

I don't want to read a novel on a computer screen! Frankly, I don't want to read ANY document longer than a page on a computer screen.

Agree wholeheartedly, but many of our 3rd party vendors use owners other than dbo. Causing plenty of expected confusion. Same sort of vendors who insist on using the...

Nice basic (but detailed) article. Very good and well worth reading for someone not experienced in DTS.

>>"admins hate it worse since most of them can't type that well."

Steve, you're kidding, right? I've never noticed this tragic inability of admins to type. LOL. There...

Interesting, though a bit long winded way to do it. Lots of good tips in this thread though.

Lol - yeah, what that guy said! Results of a survey like this *might* be useful to pick out a few ideas I hadn't thought of for my memo...

We have servers that check every 30 seconds, and alerts us to blocking chains. However, our worst blockers are 3rd party apps that just block sometimes, nothing can be...

Happily, in SQL Server 2005, you can just set the option "Include column headers when copying or saving the results" under Options|Query Results|SQL Server|Results to Grid. Woo hoo!!

""Heads-down coders" are going the way of the dinosaur."

I first heard this in around 1986. It's popular to say, it's conventional wisdom, and like much conventional wisdom, as they...

We use xp_smtp_sendmail to send email notifications. Works great. In the context of this article, it would just be an Execute SQL task.

"The design of the DatabasesBackupStrategy table is very poor."

Ouch. Might be nicer to say ""The design of the DatabasesBackupStrategy table could be improved upon by doing this...".

Yes, we deal...

Nice article! I really had to "think" my way through this one, but its likely to be very useful.

LOL. This is a joke, right? You must be in a northern/eastern IT shop. If anyone curses in an interview here at any shop I've worked...