Geek City: What gets logged for SELECT INTO operations?

Posted by Kalen Delaney on SQL Blog See other posts from SQL Blog or by Kalen Delaney
Published on Tue, 15 Mar 2011 19:41:00 GMT Indexed on 2011/03/16 0:15 UTC
Read the original article Hit count: 255

Last week, I wrote about logging for index rebuild operations. I wanted to publish the result of that testing as soon as I could, because that dealt with a specific question I was trying to answer. However, I actually started out my testing by looking at the logging that was done for a different operation, and ending up generating some new questions for myself. Before I starting testing the index rebuilds, I thought I would just get warmed up by observing the logging for SELECT INTO. I thought I...(read more)

© SQL Blog or respective owner

Related posts about internals

Related posts about recovery models