That doesn't make sense. The data returned should be less if you select individual columns.

How are you selecting? Are you sure that your SELECT * from MyTable doesn't have some...

One thing to think about is that if something has changed and your DTS package needs input, like responding to an error in Access or something, then the package freezes....

It is a presumption that everyone here knows these basics. New people come to the site every day, and to SQL Server for that matter. We want to serve all...

I almost hit a guy once. Paged me on a Thur night while I was out with my wife, just to see "if I was available". The next morning he...

Robert,

It's certainly not simple. I've seen people fight this issue in hospitals as well.

The login is hard. It really takes some long conversations with management and users to come...

Well I'm lucky. It's either 3 ft to grab the laptop off the dresser and RDP downstairs, walk 75 ft downstairs to the office, or another 120ft to the basement...

I'd hope more often than not I have casual friends at work, people I could see outside of work.

However the discussions or topics I'd talk about with friends, aren't necessarily...

I'm not sure it's as simple as #1. A "feature" might be quite large and have many parts. What if one doesn't work as expected, or perhaps not as desired?...

Actually I think if the soft skills aren't there, if you don't fit, you shouldn't get hired. And you shouldn't take the job.

Soft skills are critical in my opinion, and...

Here, here!

I know that I wouldn't want to go through one, but I think having a certain amount of apprenticeship in our business would be a good thing. Now if...

Robert,

I definitely appreciate that work needs to get done. That's why I don't want to impose more work on people. If I have something I want them to change, I...

Apologies for the spelling/grammar mistakes. I worked with the author to make changes, but I must have released the wrong version. I see spelling mistakes that I remember correcting, so...

I don't think I've had any horrible jobs. Some were hard, some required lots of hours, some had lots of stress. But I learned something from all of them and...

I think you're gambling. What works well for Michael or anyone else might not work for you.

Take the downtime, defragment in stages if necessary.

Secure FTP would work, though I'm not sure how that would integrate with SSIS.

Perhaps Secure tunneling at the network level? There's a secure TCP/IP connection method that you can setup...