Post reply

Table Partition

  • July 30, 2013 at 4:45 am

    #280728

    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

  • July 30, 2013 at 5:00 am

    #1636913

    Moving data to another file (or deleting data) does not shrink the file.

    You need to manually shrink the file to make it smaller, but this can lead to all sort of issues, such as fragmentation for example.

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

  • July 30, 2013 at 5:17 am

    #1636919

    Above database sizes are after shrink only with simple recovery model and

    mdf & ndf files are increased after posting new data into that partitions.

  • July 30, 2013 at 7:42 am

    #1636986

    What's the used space of each file?

    How did you move the data between partition?

  • July 30, 2013 at 8:01 am

    #1636995

    Oliiii (7/30/2013)

    What's the used space of each file?

    How did you move the data between partition?

    1.Some ndf files having 20 GB and some ndf files are having 5 GB(based on data)

    2.Just i inserted data into that table, based on partition date ranges it is going relevant partition.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply