How to partition an already populated table

• ernesto780411

  SSC Rookie

  Points: 25

  More actions

  August 3, 2010 at 11:36 am

  #238431

  This question is about the T-SQL syntax that leads to partitons an already existed table, I have a very large table an I want to split it to several partitons, so the question is Is it possible to split table after its creation and after the fact that it has been already populated?

  Thanks

• Ashwani Malik

  Ten Centuries

  Points: 1140

  More actions

  August 3, 2010 at 12:20 pm

  #1201731

  Does it have clustered index on it?

• Ashwani Malik

  Ten Centuries

  Points: 1140

  More actions

  August 3, 2010 at 12:23 pm

  #1201733

  Check this link from one of my favorite Bloggers-Muthusamy Anantha Kumar aka The MAK

  http://www.databasejournal.com/features/mssql/article.php/3647561/Data-partitioning-in-SQL-Server-2005---Part-V.htm