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

Us Jones' stick together. Or make mistakes together, not sure which.

I think the rant was a little emotional, and a little off track. It pointed out, however, that you ought...

Or right click the table in SSMS, script a select or insert to the query window. Then copy the fields to the insert and the select.

If you want point in time recovery, you need to have log backups. Set them up, maybe once an hour to start, and keep all log backups since the most...

What's quickly? What have you measured? What is the load on the db over that time? How many insert/update/deletes?

I was going to suggest the diff scenario. Apex Diff works well, as does Red Gate's Data compare (I work for Red Gate).

I don't think merge would work unless the...

One more note. Be sure that you keep a document of issues. As you can't do something, note what it is, what impact is has on your job or the...

You shouldn't be worried about the time for a restore if it's not your responsibility. It might be a concern, and that is something you raise to your manager, but...