I'd rebuild all indexes, which will update statistics and ensure things are OK, including removing fragmentation. I might double check the fill factors, checking if I need less or more...

Look up processor affinity.

The plans are stored in msdb. If you back that up, you're OK. I think sysmaintplans has the binary if you need to grab that.

Do not run this as a single delete. If you do, it's one commit, and it's one transaction, and it's still logged in the transaction log. You want to delete...

RAID is redundant array of independent disks. If you don't understand RAID, I'm not sure you're the person to provide hardware requirements. You might want to let them know that...

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...