Home Forums SQL Server 2005 Business Intelligence Foreign key constraints in data warehouses RE: Foreign key constraints in data warehouses

  • March 12, 2008 at 1:02 pm

    #788754

    Kerry Bennett (3/11/2008)

    I always declare fact to dimension foreign key constrains in SQL Server 2005.

    However I do not enforce the foreign key constraint, nor define any cascading event actions.

    I have not tried this, but I think that I would be OK with it.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]