You've defined a mathematical paradox there. -2.5 is greater than -5, so your rules are overriding each other. When you say "greater than -5", do you really mean...

As mentioned by others already, the use of surrogate keys (like ID or GUID), clustered indexes on them, primary keys vs clustered indexes, etc., etc., etc., really depends on what...

Definitely the correct handling in this case. Good work.

JamesMorrison (5/14/2012)

---

GSquared (5/14/2012)

---

Have to admit, I'm amazed this discussion is being resurected yet again.

Since the last time it hit the active threads, I've concluded that the lack of senior DBAs...

Have to admit, I'm amazed this discussion is being resurected yet again.

Since the last time it hit the active threads, I've concluded that the lack of senior DBAs is directly...

Jeff Moden (5/12/2012)

---

Elliott Whitlow (5/12/2012)

---

As a further point, I dislike most aspects of technical interviews purely because in MANY cases they are very subjective and if you don't give them...

Steve Jones - SSC Editor (5/4/2012)

---

You may be right. I haven't done enough formal SCRUM to know. But I have seen things slip down the list. It's not that someone...

michael vessey (5/8/2012)

---

I'm not sure if reading good suggestions from this forum would prevent many of newbies from being "promptly escorted off the premises" after interview with some of us...

Steve Jones - SSC Editor (5/4/2012)

---

Great advice from Gus, but one thing I'd also add to my list to circle back on is to make sure that you round robin...

Steve Jones - SSC Editor (5/4/2012)

---

I think you're both off track slightly here. Apple doesn't do well because of sales. They do well because they've made very intuitive products that...

RobertYoung (5/4/2012)

---

GSquared (5/4/2012)

---

RobertYoung (5/4/2012)

---

GSquared (5/4/2012)

---

RobertYoung (5/3/2012)

---

If you've ever been in sales/marketing, or know well someone who is, then you know their mantra: "any moron can sell a good product,...

Are you talking about locally installed databases, or about two users connecting to the same database on a server?

If local, check the setup at each. It's probably SQL Express,...

RobertYoung (5/4/2012)

---

GSquared (5/4/2012)

---

RobertYoung (5/3/2012)

---

If you've ever been in sales/marketing, or know well someone who is, then you know their mantra: "any moron can sell a good product, they're just...

I'd have to actually see your system, your database, and your data to take this any further. I'm not in a position to do that, but I'm sure you...

Generally, a consensus is easy to get if people just sit down and communicate about it. Arguments are more likely where open communication isn't possible/allowed.

If you have someone who's...