SQLKnowItAll (5/15/2012)

---

Well, of course it depends... I still don't see your justification for Microsoft having a lot to answer for. Its likes saying that Nissan has "a lot to answer...

I don't believe there can be any sound basis for saying that primary keys should be clustered "most of the time" because it depends on what criteria are used to...

erics44 (5/12/2012)

---

The vast majority of primary keys I see in all databases are on the id identity fields, I suppose because they are sequbtial and used in joins more often...

gyoung 93471 (3/29/2012)

---

David,

I'm appreciating all answers as I'm learning a lot. Lynn's and Sean's responses made sense to me as did the customer purchase example. But what you've done...

Sean Lange (3/29/2012)

---

It is actually the very capture of this point in time data that makes it denormalized. The point I think we all made is that this is a...

Sean Lange (3/29/2012)

---

Well in truth if you include the customer's current data at the time of the order in the order table you can't possibly be in 3NF because it...

Lynn Pettis (3/28/2012)

---

In true third normal form, for instance, a Sales Order would not have any customer information in the order header record except the Customer Number (the link betwen...

http://www.sqlservercentral.com/Forums/Topic1274466-391-1.aspx

A candidate key has to be a bit more...

From a conceptual modelling perspective ORM is more powerful and expressive. In my experience ORM is a more effective medium for communicating complex concepts and business rules than either UML...

No, it's still just as useless as it always was.

Can I export and load into Visio to create a reversed...

Welsh Corgi (3/24/2012)

---

Could someone please help me explain to a nontechnical person why it is bad practice to use the Natural Keys from the source systems as the Primary key...

This is the sequence I would expect:

1. Deltas come into some staging table

2. Surrogate keys are assigned in staging table

3. If staging table has a foreign key then that is...

Design patterns apply wherever design...

What Nick said was "relational star schema" - a...

ALZDBA (2/15/2012)

---

maybe this attached sproc can get you started.

its goal is to generate a sequence of drop fk, convert pk 2 clustered, create fk encapsulated into a transaction per pk....