Not permitted in the USA: scambling a Yegg would be a cruel and unusual punishment.

Nice straightforward question and unambiguous answer options.

But rather that that odd chunk of code with the odd choice of languages the explanation would have done better to say simply that...

hart

Well, I got it wrong. Since TRUNCATE TABLE is listed under DDL commands in BOL, while the BOL page on Lock Modes clearly states that TRUNCATE TABLE is a...

ChrisM@Work (3/21/2013)

---

Around 10 years ago whilst on contract for a telecomms company in Central London, I was introduced to a newly-hired DBA who wasted no time in rolling up his...

Hugo Kornelis (3/21/2013)

---

L' Eomot Inversé (3/21/2013)

---

I guess if you are in a situation where you can't use foreign keys, which is what you appear to be saying, the question of...

dwain.c (3/20/2013)

---

Lynn Pettis (3/20/2013)

---

I am really wondering how some people manage to get into contracting when they have no idea how to write good, performing code and expect a free...

marlon.seton (3/21/2013)

---

Hi Hugo,

Thanks for your reply.

By 'why bother' I guess you're meaning why bother using triggers instead of cascade delete? Because the 4GL in which we write the application can't...

Hugo Kornelis (3/21/2013)

---

One possible reason...

marlon.seton (3/21/2013)

---

Lokesh Vij (3/20/2013)

---

+1

same here. i feel it...

demonfox (3/20/2013)

---

I prefer not to have delete cascade on design .. to let the error display...

It's a nice clear question with a nice unambiguous answer.

I'm a little bothered by the statement that on delete cascade means that if rows in several tables reference a key...

Some rough ideas:

1) if the requirement that each table contains everything inserted in the other table up to the point where the server supporting that other table crashes, you need...

demonfox (3/19/2013)

---

It seems to use ISO-639-2 some of the...

Well, just to keep Toreador happy I'll reply, although completely off...