Home Forums SQL Server 2005 Administering Query on converting the non Partitiontable to Partion table RE: Query on converting the non Partitiontable to Partion table

  • February 25, 2008 at 7:18 am

    #781536

    Preethiviraj Kulasingham (2/25/2008)

    I suggest that you should explore one of the two solutions (but not both):

    1. Create the primary Key as NON CLUSTERED

    2. Think about partitioning the table based on Primary key

    Cheers,
    Prithiviraj Kulasingham

    Plan to Test your Plan!