SQL Table partition RRS feed

  • Question

  • Hi,

    We have archival tables which are already partitioned. I want to add monre partitions for last year meaning 12 partitions, one for each month. I added for January it worked withinh 13 minutes. When I tried to add for Feb it takes more than 3 hours and the transaction log of DB get filled up. I am not sure why this happens. I am unable to proceed further because of this issue.


    Thursday, August 17, 2017 4:51 AM


All replies