Post reply

Switch partition on Columnstore Index table

  • August 28, 2013 at 7:18 pm

    #298269

    Hi

    I understand that to update a Columnstore index table, one method is to switch to staging tables. I have a question, let say I need to switch 3 partition OUT at the same time (in order of Partition 1, Partition 2 and Partition 3), after update, am I able to switch the partition back in random order (eg: Partition 2, Partition 1 and Partition 3)?

    Thanks.

  • August 28, 2013 at 7:51 pm

    #1645805

    My advice is to set up a test and actually do it to verify (and learn in the process). Partitioning REALLY isn't something you want to learn about from some forum posts and then roll into production! 🙂

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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