Partition of table RRS feed

  • Question

  • How do we partition of table when lots of data available in table.
    Monday, July 19, 2010 5:08 AM


  • Hello,

    To use partitionned tables you have to define morte than one file group on your database, define the partition function, the partition schema and finally create the table using the defined partition function on the schema definied with the different file groups.

    See this aricle for details http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx      


    • Proposed as answer by Tom Li - MSFT Thursday, July 22, 2010 7:46 AM
    • Marked as answer by Tom Li - MSFT Monday, July 26, 2010 1:38 AM
    Tuesday, July 20, 2010 1:22 PM