I guess it says something about our geekiness that our "water cooler" conversation has to be policed periodically for overly technical matter. This bit about normal forms says something...

GilaMonster (6/29/2009)

---

GSquared (6/29/2009)

---

6NF is either Domain/Key NF or Temporal NF, per...

Gianluca Sartori (6/29/2009)

---

GSquared (6/29/2009)

---

2. You include columns like FirstNameID, LastNameID, and reference a Names table. If you need to find everyone named Fred, and the ID for Fred is...

GilaMonster (6/29/2009)

---

GSquared (6/29/2009)

---

What I think is funny is the people who think that "normalizing" is replacing all the data with ID FKs to other tables. Like, instead of having...

Gaby Abed (6/29/2009)

---

Regarding the Nth Normal Form, and I guess on a more philosophical level, is it true that the more normalized a database is, the less fragmentation occurs so...

It's the collation.

Check out the data on "Code page 850" online. Character 153 is the O with dots, not the TM, in that code page.

So do I.

I have a Dilbert strip, the XKCD about Little Bobby...

GilaMonster (6/28/2009)

---

Lynn Pettis (6/27/2009)

---

Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was in when I had my...

smsam1 (6/27/2009)

---

table Results contains (student_id,subject_id,marks ,has_passed) as attributes. with the composite primary key (student_id,subject_id)

2). i wanna make sure that can we tell that 'has_passed' is transitively depend on...

I've taken over DBA duties twice now, at two different companies. Both had backup plans in place. Neither had ever tested them. Both were backing up to...

I have a simple list: Enough to do to keep me engaged, enough pay for my plans and goals, co-workers I can get along with. I'm easy to please.

What does nchar(8482) give you?

Try:

SELECT My_DATE

from dbo.MyDatabase

WHERE ISDATE(My_DATE)=0;

That's more likely to catch what you're running into.

The only oddball one I could come up with would be that whatever space I'm staying in (hotel room, whatever) shouldn't have been recently cleaned with perfumed products, and no...

Since I've found that I can trust the vast majority of people, I start out by trusting and then stop doing so if it's warranted. Makes it much simpler,...