Jack Corbett (6/14/2012)

---

Okay, I got it wrong. I personally create constraints (other than PK and DEFAULT) separately from the CREATE TABLE statement, so when it says "...

venoym (6/14/2012)

---

If I may. I answered Clustered. The reason is that I was trying to divine the intent of the author. Is the intent to test your...

Koen Verbeeck (6/13/2012)

---

chris.j.clague (6/13/2012)

---

Really, staging table and a merge statement is all you need (2008+). For 2005 I'd just use a proc to replicate the functionality of the merge statement....

L' Eomot Inversé (6/13/2012)

---

I suspect the point he is attempting to make is that a competent administrator will succede, not fail, because if he knows the port numbers he can...

+1 🙂

Personally I've just started working with Service Broker... I was a little confused, but then I realized he meant SQL Browser...

So the (Nolock) hint is probably allowing for a read where it should be blocked while the next order is being generated.

Something like this should help.

I don't see where @NextOrderNo...

GilaMonster (6/7/2012)

---

Doesn't mean he's write exactly that in exactly the same format with the same odd variable naming and indentation.

I find if very strange you're calling someone a sloppy coder...

Cadavre (5/25/2012)

---

If I was asked this in an...

GilaMonster (6/7/2012)

---

mtassin (6/7/2012)

---

Jeff Moden (6/5/2012)

---

As a side bar, anyone who writes code as well formed as Cadavre did, even though it was a loop, has already caught my attention. ...

Jeff Moden (6/5/2012)

---

I've tried the ol' FizzBuzz test on some folks. A lot of them can't even begin it because they have never worked with things like Modulo (%)...

Brandie Tarvin (6/7/2012)

---

I'm sure this will come off sounding stupid, but I have never heard of Fizzbuzz. I see the solutions, but I don't understand what you're solving.

Could someone elaborate...

I had a minor worry about it, but I also...

Cadavre (5/25/2012)

---

If I was asked this in an...

jeff.mason (6/1/2012)

---

Not so much a guess for me as process of elimination -- I have had to make use of the other three constantly as a DBA, so that was...

Me too, though I learned about Master not allowing differential backups, Tempdb not allowing any was the obvious answer.