Question on partioning

• M&M

  SSC-Insane

  Points: 21700

  More actions

  September 15, 2010 at 11:35 pm

  #240491

  After implementing table level partioning, how to verify if the partitioning is really implemented. That is, after you enter appropriate values based on partition range, I want to verify if the entered values are going to the correct partition.

  Please share your inputs.

  M&M

• Ali Tailor

  Hall of Fame

  Points: 3769

  More actions

  September 16, 2010 at 12:31 am

  #1221915

  Hi

  Mohammad let us know u done the Vertical OR Horisental partitioning.

  and In my opinion issue a select query to know where apropriete data entered?

  Ali
  MCTS SQL Server2k8

• M&M

  SSC-Insane

  Points: 21700

  More actions

  September 16, 2010 at 12:32 am

  #1221917

  It is horizontal partitioning. But from select statement, how do we know?

  M&M

• Ali Tailor

  Hall of Fame

  Points: 3769

  More actions

  September 16, 2010 at 12:40 am

  #1221924

  hi

  visit

  http://blogs.msdn.com/b/craigfr/archive/2008/07/15/partitioned-tables-in-sql-server-2008.aspx

  Ali
  MCTS SQL Server2k8

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  September 16, 2010 at 12:43 am

  #1221926

  use the sys.partitions view

  for detail can be found in http://www.sqlservercentral.com/articles/partition/64740/

  "More Green More Oxygen !! Plant a tree today"