Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Switch partition on Columnstore Index table

Author  Topic 

ryanlcs
Yak Posting Veteran

62 Posts

Posted - 2013-08-29 : 01:31:48
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.
   

- Advertisement -