You've got someone running transactions, sorts, or creating temporary tables with lots of data. We had users starting an ORDER BY query (no parameters, bad joins, bad search criteria) that,...

In terms of a join, don't adjust anything. If the column is null, it doesn't equal anything and that row won't be returned which is as it should be.

You've already laid out the issues pretty well. You can either save it in the database where:

[highlight]You get a good, clean, synchronized backup

When the user is deleted, you also easily...

You could use a view to combine the data from the four tables into a single select statement. 12,000 rows, depending on how much data is in them, is not...

I have to agree with Steve on this one. If you've had a conflict (and who hasn't) and that comes up in an interview, you need to be honest about...

this is a pretty regular debate. I usually fall back on business requirements to help decide.

The one technical issue that does help decide is backups. If you store the...

Well, there you go. Trigger is the trick then.

You don't have to use a trigger.

You could use the OUTPUT clause from the insert statement:

INSERT INTO TabA (Col1, Col2)

OUTPUT Inserted.Col1, Inserted.Col2 INTO TabB (Col1,Col2)

VALUES ('A','B')

Because of the naming conventions (you're right, they're horrible), it's hard to tell exactly what's happening in the "generic" design. However, looking at your design, it sure seems to me...

Congratulations.

Yes, you should learn tons & tons. When you've only yourself to rely on, you start learning things very, very quickly. Remember that automation is your friend. Spending an hour...

The only time I had to do this I was using an application to take the output from a stored procedure and then save it to a file. I haven't...

I'm sorry, no, becuase, I think like everyone else, I still don't understand what you're trying to accomplish...

If I understand the question, you can simply use the Database Diagrams to see all the tables and their relationships. Assuming those relationships in your database are all through primary...

D'oh!

Did Steve see?

And following up on what Matt says, you want to know that too. Except for extreme circumstances (you're about to lose the house, the family is hungry, etc.) lying your...