Can you post the DDL for both tables? Basically you'd

insert Destination (col1, col2, col3, col4)

select col1, col2, default_for_3, default_for_4

from SourceTable

It's hard to say what you should do. Is the data needed there?

You have 2 choices.

1. Put the columns that are in the source in the list and then use...

If you feel someone using the product is good enough, then that's your opinion. You shouldn't push that on others, or assume that other software developers feel the same way....

Yes, but be sure this is what you want. In a FK, you have to remove all children before you can remove a parent. Note that you might have multiple...

The queries will not likely have memory leaks. You're using basic SQL that has been exhaustively tested. I guess it's possible, but I haven't seen it in years of doing...

Open Source != free. It means that someone is allowing you to see how the code works.

Lots of these little utilities are written by someone that does it in their...

You are trying to delete rows that have a FK reference. You need to delete the child rows before you can remove the parent.

I think you need a subquery or a CTE.

I see Seth has posted what I'd use.

SQL server doesn't have any memory leaks that I'm aware of here. Likely you are having IO issues. I've seen this when the firmware or drivers for the HBAs are...

This should work, providing that you have the proper columns linked. Note that you're writing an old style join, which is not recommended. You ought to write something more like:

create...

I think that jives with what I remember. Be sure that you read the case studies carefully, and most of the study guides should help you with this.

What's your job? Are you a developer or production DBA? Are there things you were supposed to accomplish? Or think you should have?

I'm slightly confused. Are your objectives looking back...

Note that what you appear to want is not load balancing, but rather restricting the use of resources between databases.

Using VMs will give you some control, but at the expense...

I'd agree. If you use it, $25 isn't much, and it helps a fellow programmer that's written something.

You're looking at this wrong. And that's why it's not making sense. You are changing the parent, which is fine, and the child stays linked. But you're saying you want...