Partition Tables

• sureshjevani 78421

  SSC Veteran

  Points: 244

  More actions

  March 12, 2015 at 8:43 am

  #295942

  I partition few tables on yearly basis and would like to find out that the data from all these tables goes to the correct yearly partition and then match the total rows. Need help with the sytax. Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  March 12, 2015 at 9:04 am

  #1783604

  You can use the sys.dm_db_partition_stats dmv to find the number of rows per partition for your table.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP