As an alternative, what about creating an unscheduled job to fire off the DTS package, and starting the job from osql? At least then the DTS package would be running...

As Michael said, it's impossible to say for sure what is causing the performance bottleneck without more information (although based on some guesses as to how things are structured, it's likely...

Just a minor note to add regarding your manager's technical and managerial skills. While I think it's imperative that a manager have good managerial skills, and it sounds like your's needs...

We need a sticky.

Keep in mind that Peter's "CASE" solution, which is indeed ideal if you have a fixed number of columns, won't work if you have a dynamic number of columns to...

Color me confused as well.

You can run bcp on the destination, pulling the data from any machine that it has access to, whether that machine has SQL Server installed or...

"I would be interested to know if anyone knows the kinds and volumes of numbers used in digital signal processing where- or so it was said on these two theads...

It wouldn't be my first choice, based on your job description, but the description doesn't show which aspects are emphasized, and I'm also not an HR person, so I wouldn't...

If you want to get fancy, you could use something like "Heterogeneous Hybrid DBA", but as long as the job description is visible, even the simple "DBA" or "Hybrid DBA"...

While the plans should be the same for an inner join, that's not always the case with outer joins. That's one reason that it's best to standardize on one method...

Since SQL Server is not inherently 9 times slower than Sybase, there's no definitive answer I can give without getting a lot more detail. It could be caused by anything from cached versus...

Jeff,

"Futility. That there's a time when you should just give up"

There's a lot of truth in this one. To be honest, the only reason I've stuck with this so long...

What the hell, it's not like you're actually going to prove anything, and this stuff is way too easy, so here goes.

1) The way TR rounds 0.1250 shows that it...

Happily, and since you're way behind in question answering, coding, proving, etc., you get to go first.

Tons of proof, which I've repeatedly brought to the table. Hell, I even proved that you were correct in how BR handled .1251. Still waiting on the answers to my...