Post reply

Inserting to Right Partition Question

  • August 9, 2016 at 10:25 am

    #328858

    guys-

    Im inserting 1 billion rows into a partitioned table, I notice that while the insert is taking place, the partition scheme is not being implemented, meaning all the data is loaded into the primary partition. Is this normal behavior for 2014 and or SQL or is my scheme perhaps not correct?

    Im guessing that SQl performs the scheme after the insert transaction is done, but not sure how it designates the scheme before, during or after the inserts.

  • August 9, 2016 at 11:13 am

    #1894609

    Ok, so i did a smaller batch with @@rowcount and found that sql does indeed load to primary before scheme is kicked off. As such it behooves me and you to do inserts in batches not only for tempdb usage but also your primary partition scheme to not get too full.

    Hope this helps someone.

Viewing 2 posts - 1 through 1 (of 1 total)

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