Change the clustered index on a large table.

• hisorna-782455

  SSC Veteran

  Points: 241

  More actions

  July 6, 2009 at 9:21 pm

  #384927

  I have a large table (with 44 million records) in which the primary key is clustered. Now I would like to make the primary key non-clustered and add a clustered index based on another field.

  Wonder what is the best way to achieve this with minimum or no downtime.

  Any help is appreciated.

  Thanks.

• WayneS

  SSC Guru

  Points: 95460

  More actions

  July 6, 2009 at 9:33 pm

  #1020849

  Duplicate post, please post replies here.

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2