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

Truncate and snapshot isolation Expand / Collapse
Posted Tuesday, October 22, 2013 9:18 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 4:57 AM
Points: 875, Visits: 1,760
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?
Post #1507213
Posted Wednesday, October 30, 2013 7:33 AM



Group: General Forum Members
Last Login: Monday, April 14, 2014 10:01 AM
Points: 2,980, Visits: 762
You probably want to read SQLSkills posting from Paul Randall and Kimberly Tripp to understand the effects of what you want to do.

Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
Post #1509772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse