Table Partition

• PRAMANA.DBA

  SSCertifiable

  Points: 5507

  More actions

  July 30, 2013 at 4:52 am

  #281146

  Hi All,

  I have partitioned VOICE_CALL table, size=130 GB(spill-ted into 10 ndf files) But

  before partition mdf files size 350 GB,

  After partition mdf file size 351 GB.

  10 Ndf files size 99 GB so total database size is 449 GB

  Why mdf file size not decreased ? even-though I was moved data to ndf files ?

  Thanks,

  Ramana

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  July 30, 2013 at 4:59 am

  #1636911

  Please do not crosspost. It wastes peoples time and fragments replies.

  Original thread can be found here:

  http://www.sqlservercentral.com/Forums/Topic1478917-2799-1.aspx

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