Truncate and snapshot isolation

• winston Smith

  SSCoach

  Points: 19497

  More actions

  October 22, 2013 at 9:18 am

  #284886

  When Snapshot isolation is enabled, any updates will first store a copy of the rows to be updated in the version store BEFORE updating.

  Does this occur with TRUNCATE TABLE also? i.e. if I truncate a table, and its a super mega huge table, will the rows be queryable via the version store while the truncate is in progress?

• Thomas LeBlanc

  SSCrazy Eights

  Points: 8075

  More actions

  October 30, 2013 at 7:33 am

  #1662705

  You probably want to read SQLSkills posting from Paul Randall and Kimberly Tripp to understand the effects of what you want to do.

  http://www.sqlskills.com/blogs/paul/

  Thomas LeBlanc, MVP Data Platform Consultant