Relation Only, or with Foreign Key Constraint?

Almost too basic description of the options in the Dataset Relation dialog.
Smart Client Data : Relation Dialog: Relation Only, or with Foreign Key Constraint?

On the virtues of crap code

Sometimes you just have to wonder what people are thinking. What level of software engineering degree does it take to completely misunderstand a concept and write this very special code?

SqlConnection conn = _db.GetConnection();
SqlTransaction tx = conn.BeginTransaction();
SqlCommand cmd = this.GetCmdRemoveField(conn);
cmd.Transaction = tx;
cmd.Parameters.Add("@ID", id);
cmd.Parameters.Add("@FieldName", field);
cmd.ExecuteNonQuery();
tx.Commit();
conn.Close();
try { tx.Rollback(); }
catch { }
conn.Close();

My eyes bleed and my heart sunk as I found this code from an external development group that was developing part of the previous application I worked on.

SQL Deadlock Troubleshooting

SQL deadlocks can happen in the funniest places and when you least expect them. Take for example one website that had no problems with 1-2 users, but when 'scaling' to even 4 users SQL deadlocks would start. The blog entry below is well worth the read to help debug those pesky deadlocks.

Bart Duncan's SQL Weblog : Deadlock Troubleshooting, Part 1