Browse by Tags

• indexes
• transaction log

• Geek City: What gets logged for SELECT INTO operations?

  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 Read More... Posted Tuesday, March 15, 2011 1:41 PM by Kalen Delaney | 12 Comments Filed under: internals, transaction log, recovery models

• Geek City: What gets logged for index rebuild operations?

  This blog post was inspired by a question from a future student. Someone who was already booked for my SQL Server Internals class in June asked for some information on a current problem he was having with transaction log writes causing excessive wait Read More... Posted Tuesday, March 8, 2011 11:54 AM by Kalen Delaney | 15 Comments Filed under: internals, indexes, transaction log, recovery models