Table Partitioning Help

• tooba111

  Right there with Babe

  Points: 767

  More actions

  November 30, 2012 at 5:47 pm

  #265597

  Hi Gurus,

  Is someone can help me with Table Partition? with e.g or show me tutorial that would be awesome.

  Thanks in advance.

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  December 2, 2012 at 10:56 pm

  #1564732

  MSKB is your friend... that and Books Online.

  http://technet.microsoft.com/en-us/library/ms188730.aspx

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  December 2, 2012 at 11:09 pm

  #1564734

  http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table

  The above link has scripts that u can use , I suggest you first read up on partition function and partition scheme before trying them out. Also you need to understand that table partitioning is mainly used to manage a large table t you need to identify the right column on which to partition by and how to use the swap of partitions.

  Jayanth Kurup[/url]