ah, sorry. I know you like your job from other comments and emails.

I think if you can find a good place to work, try to stick there. Good places are...

I don't know about the product, but not sure I'd pass. Maybe they'd like an upgrade? Could be some nice long term income if they have $$

This is dicey as SQL Server is very intolerant of network delays. File copies are more tolerant. I'd recommend backup/restore from the local disk.

I'd do two plans, otherwise, follow Markus' advice.

Haven't seen this before. It looks like it could be a bug. I'd call Microsoft's PSS.

Do you mean the formatting or the alias or both?

Not sure what the problem is?

Backups - Use a maintenance plan. I'd set up daily or weekly full backups and then log backups every hour or so for critical databases, maybe daily on others. You'll...

Peter has a great suggestion.

That's strange. Are you sure someone didn't run a manual backup? Did the server time change and the job run twice?

I'd dig in more to the logs and scheduler to...

Can you give us an idea of how you store these items in the tables? Jeff has a good suggestion, but it's hard to know if a left join is...

Just an FYI, most people won't want to read through all this stuff. Pick out an error or two and just post that. Lots of gurus will ignore this for...

Right click the db, Generate Scripts. Be sure indexes are checked and save this file.

Lowell has some good advice, but also how do you know things are slow? It sounds silly, but slow is subjective. Ask someone to run a query, have a stopwatch,...

I'd vote with a split based on how often you query/need the data. That's relative. If you're looking up patient name, dob, address most of the time and less often...

Toronto should be a good number. It does depend somewhat on experience and how you sell yourself. If you can do the work, get what you can.

In Denver, I charge...