How to change a table from db patition to table partion

• koteswara kishore K.

  Ten Centuries

  Points: 1122

  More actions

  January 13, 2009 at 4:25 am

  #129963

  Hi All,

  I have a table with 70 million records which is created in PRIMARY db partition and having many constraints, reference.

  Now i want to apply a table partition on this table for performance improvement.

  How to change(requesting for script) table from PRIMARY partition to table partition(i.e. partitioning schema).

  I am able to create partitioning on new table. But i am looking to apply table partitioning on existing tables with out loosing records.

  I am not intrested to create a snapshot of the original table and drop the old. It is very risk.

  Help to me.

  Thanks,

  Kishore KK.

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  January 13, 2009 at 5:23 am

  #925766

  I don't think this is possible without creating a new table.

  If someone knows the solution then I am also interested in it

  -Vikas Bindra

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  January 13, 2009 at 5:30 am

  #925770

  Did you read:

  -SQL2005 http://msdn.microsoft.com/en-us/library/ms188706(SQL.90).aspx

  -SQL2008 http://msdn.microsoft.com/en-us/library/ms188706.aspx

  -WP: http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

  - http://www.sqlservercentral.com/articles/SQL+Server+2005/61765/

  - http://www.sqlservercentral.com/articles/Development/3144/

  - http://msdn.microsoft.com/en-us/library/ms345146.aspx

  - http://www.sqlservercentral.com/Forums/Topic414210-338-1.aspx

  - http://www.sqlservercentral.com/Forums/Topic623669-360-1.aspx

  also keep in mind, if partitioning an existing table, you may still end up with DOWN TIME for your application(s) !

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me