Home Forums SQL Server 2008 SQL Server 2008 - General Would you store foreign key from grandparent tables? Why or why not? RE: Would you store foreign key from grandparent tables? Why or why not?

  • November 27, 2012 at 11:59 am

    #1562807

    ill add a little of my view to sean's. in an OLTP (Transaction) system i would say it would be very limited where i would de-normalize, i would not recommend it as a first choice tool. there are times (and in my current job before i got here they de-normalized the structure) where it can make sense but that determination is probably not going to be made through a forum thread.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]