Home Forums SQL Server 2005 Administering Copy Between 2 and 3 billion rows from a heap table with no key to a new partioned table. RE: Copy Between 2 and 3 billion rows from a heap table with no key to a new partioned table.

  • January 10, 2013 at 10:31 am

    #1575893

    Hello,

    1st of all sorry for creating a duplicate topic it was an user error. I noticed it only after I created the 2nd. I was not able to delete.

    The current partition key does represent Months. 1 = '01/1989', 2 = '02/1989', 3 = '03/1989'..... Any Ideas on what I can do to copy the data to the partition table?

    thank you,