Column Store Disabling

• sudhirnune

  SSCrazy

  Points: 2342

  More actions

  October 17, 2015 at 11:27 pm

  #309013

  Hi All,

  We have a typical issue with Column Store Index, we have a procedure which does 2 activities - Switch & Reverse Switch

  Switch:

  1. Fetch the Partitions needed to be switched

  2. Switch the data from Main Table to Switch table

  2. Disable the Column store on Switch table

  SSIS Package:

  3. Load data to Switch (Insert / Update)

  Reverse Switch:

  4. Enable the Switch

  5. Switch back the data from Switch table to Main table

  Issue: Some time the Column store is not getting disabled, and the package fails complaining try disabling the Column store index and try loading data.

  If we re-run the procedure, the column store gets dis-abled, please need you help and any details if this is some sort of BUG

• Eirikur Eiriksson

  SSC Guru

  Points: 182920

  More actions

  October 18, 2015 at 12:14 am

  #1833954

  Quick suggestion, query sys.indexes to check if the columnstore index is disabled or not before attempting to manipulate the data.

  😎