denis.hosdil (10/26/2010)

---

Agreed.

Our Database - about 200 tables - is about 80% Surrogate/ 20% Natural.

The below is an example where we too prefer the Natural.

In my experience, the...

Tom.Thomson (10/26/2010)

---

An easy example is a set of...

Robert Mahon-475361 (10/26/2010)

---

Aye. Never had problems merging DB's. That's why GUID's are so excellent and why I refer people to Quazibubble's posts.

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=6136&whichpage=3

He does a far better job...

ebay-1087924 (10/25/2010)

---

ta.bu.shi.da.yu (10/25/2010)

---

nowhere in Codd's relational model does it state that you normalize anything other than the relations themselves. I suppose if you consider a database as a gigantic relation...

ebay-1087924 (10/25/2010)

---

It means performance responds to increasing workload in an O(n) (linear) or better manner. Some people loosely use buzzwords like "scalable" to simply...

ebay-1087924 (10/25/2010)

---

ta.bu.shi.da.yu (10/25/2010)

---

1NF takes a table with repeating groups and splits them into several tables. It doesn't take repeating groups from several tables... I fail to see your point here....

What does that even mean?!?

ebay-1087924 (10/25/2010)

---

I'm sorry, but this isn't the case at all. ...

ebay-1087924 (10/25/2010)

---

Maybe you...

Robert Mahon-475361 (10/25/2010)

---

Read;

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=2

All of quazibubble's posts,...

Jeff Moden (10/21/2010)

---

ta.bu.shi.da.yu (10/21/2010)

---

Jeff Moden (2/6/2010)

---

Here's the code that my old DBA and I came up with. The day we replaced the original code with the following code, the...

Jeff Moden (2/6/2010)

---

Here's the code that my old DBA and I came up with. The day we replaced the original code with the following code, the deadlocks dropped for...

WayneS (10/14/2010)

---

If you look at these two posts, especially the signature, and that these are the only posts ever from this poster, they feel more like spam for their kitchen...

Jeff Moden (10/13/2010)

---

ta.bu.shi.da.yu (9/17/2010)

---

2. Oracle has implemented more of the SQL standard that Microsoft. Case in point: try doing a lag, lead, or top analytic function in SQL Server... you...

Lynn Pettis (10/13/2010)

---

In my opinion, nothing. Both serve a purpose and can do the job.

In the short time I have had with...