Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Switch partition on Columnstore Index table Expand / Collapse
Author
Message
Posted Wednesday, August 28, 2013 7:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, September 22, 2013 8:58 PM
Points: 1, Visits: 14
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.
Post #1489491
Posted Wednesday, August 28, 2013 7:51 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:58 PM
Points: 4,359, Visits: 6,195
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 at GMail
Post #1489495
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse