Hi

Thanks for the response. My question about the CreatedDate, CreatedBy...columns - was more along the lines of "Should I have them?" in a social networking site with 100K+ users and...

Hi all

I asked this question over at asp.net and had the suggested solution. I presume this is bad but thought I'd ask. Thanks.

In having discussions I have decided to create...

I was thinking of using a stored procedure to do this as well. This was my initial sp not taking into account disjoint subtypes yet.

Would this work, or is this...

Hi Grant

Thanks for the reply. Your explanation has helped me (mentally) greatly. I understand the Person/Location etc...relationship better now.

With regards to my problem of the Comments tables for my design,...

Hi David

Thanks again for the response and explanation. Right, I am starting to get somewhere...

Inorder to make use of your example, my tables would then look like this??? Is this...

Hi David

Thanks for the explanation. I am hitting google as we speak.

The link you sent does not seem to work - just thought I'd let you know. Thanks again.

Dave

mmmmm...ok. Forgive me if this is a little like RDMS 101 but here I go...

I always thought that 1NF design was a table that was a faithful representation of a...

Hi again Bob

I have been trying to understand your previous post re:Comments

If I was to implement option 3. I am unsure of what to do. I don't understand "DelegateID" and...

Thanks again.

OK - This looks alot more complex than I originally thought.

Given the Arc type relationship and that we would want to avoid it - How would you recommend that...

Hi

Thanks for the responses. My comments table would look something like this, if I was to implement a table for each entity:

-- Article Comments --

IF NOT EXISTS (SELECT 1 FROM...

Hi Grant

Thanks again - in one swoop you answered a big question of mine with DB design.

If the data is not needed and won't need to be maintained, it is...

Hi guys

Thanks very much, by just reading the forums I am learning alot.

You have all answered my questions exactly.

last question: Is having these columns on all tables a "best practice"...