Again, I got the right answer for the wrong reason. The fact that the topic was IDENTITY should have been a tip-off. But I'd never encountered the References...

Which means the Flag filter belonged in the WHERE clause, not the JOIN.

I think I'm starting to get it. The JOIN clause is about what gets included on the...

Okay, then how would you have written a left outer join if you wanted to fetch only the records where the left side had flag = 1?

I too had trouble with the wording of the options, and ended up picking the first (and wrong) option because the other three looked like they couldn't be true. ...

I'd be cautious if you don't know how the tables got there in the first place. We have an accounting system that utilizes work tables, which are generally empty...

Damn if you weren't right. I ran it again, and then, just to humor you of course, I began moving through 399 records one at time. At the...

It's well-written and I thought I understood, but when I tried to apply what I learned, I found something that didn't make sense. We have a 1.8G database with...

Here is the error from the job history log:

failed with the following error: "Cannot perform a differential backup for database "MCRInc_2011App", because a current database backup does not exist. Perform...

I had jobs set up to run the backups. Lately I've been running the backups by manually running the jobs because I'm in test and debug mode and can...