Michael Valentine Jones (5/18/2010)

---

meichner (5/18/2010)

...I have limited experience with this, so I guess I also have limited vision as to the problems. I am not sure that I understand...

Michael Valentine Jones (5/17/2010)

---

I have never understood the attraction of having one table with many different types of entities.

As mentioned, it is a violation of rules of normalization, so that...

Thank you so...

The section listed under the NOTES makes mention of what I need.

Thanks

The article goes half way there. What I mean by this...

Steve Jones - Editor (2/12/2010)

---

1. Yes, no major issues I've seen reported here in 18 months since RTM.

2. The setup program for 2008 will do this. You can grab an...

GilaMonster (1/25/2010)

---

Either of the examples I gave you will do that, they are (as written) identical in operation and performance.

My comments to The_SQL_DBA was not related to his use of...

GilaMonster (1/25/2010)

---

Distinct is not a function, it does not take parameters. What you have written is completely equivalent to this

Select Distinct

DG.UserID

, DG.UserName

, DG.LastName

, (DG.FirstName)

From DGUsers DG

Inner Join Orders O...

Thanks...

Ray K (1/5/2010)

---

Andrew is correct. A key indicates a single relationship; an infinity symbol indicates a "many" relationship.

For example, a connection with a key at each end indicates a...

Thanks so much to the both of you. Both statements worked perfectly. You saved me hours of time.

Grant Fritchey (10/29/2009)

---

meichner (10/29/2009)

---

Grant Fritchey (10/29/2009)

---

The Red Gate database documentation tool, SQL Doc, will do it I think.

The problem is, it's really easy to get a circular reference. All you...

Grant Fritchey (10/29/2009)

---

The Red Gate database documentation tool, SQL Doc, will do it I think.

The problem is, it's really easy to get a circular reference. All you need is a...

Al-279884 (10/16/2009)

---

Invoices table would need an OrderID column, foreign key to Orders.OrderID. Otherwise, how do you know what are you billing for?

I would not put CustomerID and AddressID on the...

Al-279884 (10/15/2009)

---

meichner (10/15/2009)

---

Al-279884 (10/15/2009)

---

John Rowan (10/15/2009)

---

Yep, it makes sense. I'm not sure if that's how I'd design it, but it is what it is. My personal preference would...