What have you tried?

If the tables exist

insert table select field1, field2, from othertable.

If you need to remove selected rows, do it in batches. You can switch to simple mode, delete 1000 or so rows, repeat, and then switch back to full mode....

You need three arguments

http://msdn.microsoft.com/en-us/library/ms189794%28SQL.90%29.aspx

Use Books Online.

Are you allowing UDP 1434 through? Or is the SQL Browser working? Those are used to resolve the port.

look up

select...into

This task will work for you. a few things to check. Do you have files that are older than that date? Are you sure the paths in the task are...

You cannot do this. If someone is an administrator on the machine, and they have control of the environment, they can possibly get in.

You can make it more difficult. You...

Likely you would need multiple passes to find typos. Duplicates would be exact matches. typically that's a

select dupfield

, count (*)

from mytable

group by dupfield

having count(*) > 1

If...

Excellent job, Gail!

We're publishing part 2 in a couple weeks and part 3 as soon as possible after that.

I think Gail is leaving tomorrow for her 400 hour, round-the-world-across-the-hemispehere trip to PASS 🙂

I don't think I said that virtualization is the preferred method for consolidation. I am pro-virtualization, and it's worth considering. As I mentioned, it's not for everyone or every instance....

I don't think the service account needs to be a local admin. If I remember correctly, we ran lots of SQL 2000 instances under a domain account that was not...

Interesting points, Tom.

I think you have hit some good thoughts here, though I'd disagree that most people can't learn to program better. I do think many are lazy, but I...

I don't see a problem for decimal for money. In fact, I've never used the money data type. I don't trust that business rules are really that set, especially with...

I haven't done a lot of this, but when we had salespeople across the US, we used UTC as a standard. That way we were sure of the timing of...