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
Author
Message
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: Thursday, September 11, 2014 4:22 AM
Points: 903, Visits: 1,868
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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 9:48 PM
Points: 3,099, Visits: 788
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, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1509772
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse