Table Partitioning in SQL 2005

• meghna.bhargav

  SSCrazy

  Points: 2634

  More actions

  March 3, 2011 at 12:27 pm

  #147419

  Hi

  Can you please tell why , when and how Table Partitioning in large tables common across Data Warehouses is implemented?

  How does it offer important performance and manageability advantages?

  Regards

• Jim Murphy

  SSCertifiable

  Points: 6263

  More actions

  March 3, 2011 at 1:09 pm

  #1294297

  Microsoft explains it well.

  http://msdn.microsoft.com/en-us/library/ms345146(v=sql.90).aspx

  Jim

  Jim Murphy
  http://www.sqlwatchmen.com
  @SQLMurph