Vertical or Horizontal table partition?

• Tac11

  SSCertifiable

  Points: 6980

  More actions

  October 16, 2014 at 9:32 am

  #294214

  I have a table with 19 million of rows and 2 col. have Uniqueidentifier and 2 have MAX data type and 5 other datatype columns, I am being told to partition/archive the table.

  Should I go to Vertical partitioning or Horizontal partitioning?

  If I do go either way, should I drop PK on the column first and recreate again for other partitions? can someone please help me on this?

• Alexander Suprun

  SSCertifiable

  Points: 6253

  More actions

  October 16, 2014 at 1:59 pm

  #1752959

  I doubt that anyone will be able to help until you say what is the purpose of the partitioning and how this table is used.

  ---

  Alex Suprun