Post reply

Partitioned Views

  • August 20, 2008 at 1:48 pm

    #191694

    I am trying to partition a large table (23MRows and growing) which is primarily an archive. I have set up the base tables and defined an appropriate Check constraint etc. The View is also defined. My problem is that how do I re-hook up the Foreign Key references to the original table. There are 4 foreign key references from a second table and the original table has 3 self referential Foreign Keys.

    Thanks

    Ray

  • August 20, 2008 at 11:42 pm

    #861031

    Ray Herring (8/20/2008)

    I am trying to partition a large table (23MRows and growing) which is primarily an archive. I have set up the base tables and defined an appropriate Check constraint etc. The View is also defined. My problem is that how do I re-hook up the Foreign Key references to the original table. There are 4 foreign key references from a second table and the original table has 3 self referential Foreign Keys.

    Thanks

    Ray

    GO TO this blog, it will usrely help you.

    http://sqlserver-qa.net/blogs/tools/archive/2008/03/12/sql-server-2005-partitioned-tables-and-indexes.aspx

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply