March 19, 2013 at 11:39 pm
when the rows will be added to tempdb(update statement, select statement) and when it is cleared ?
March 20, 2013 at 4:47 am
winmansoft (3/19/2013)
when the rows will be added to tempdb(update statement, select statement) and when it is cleared ?
Read the documentation supplied by Microsoft. They lay it out there. In the most basic way, when the transaction starts a copy is made in tempdb and reads then go there while the data is updated in the original database. When the transaction completes, the copy is removed from temdb. In actuality it's more complicated than that, but that's it in a nutshell. Again, read the documentation.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply