THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Transaction log   (RSS)
  • Geek City: Did You Know … that not everything you know is actually true!

    Software changes, new versions not only add new features, they also change internal behavior of old features,  and not all the changes are documented!  And how often, after a software upgrade, do you go through and test everything you knew was true, to make sure it is STILL true after the upgrade? I write books about the SQL Server ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 27, 2013
  • Geek City: What Triggered This Post?

    I’d really like to get another post up onto my much neglected blog before the end of 2012. This will also start one of my New Year’s resolutions, which is to write at least one blog post a month. I’m going to tell you about a change in SQL Server that wasn’t announced in any “What’s New” list that I ever saw, perhaps because it was just a chance ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 31, 2012
  • Follow-up Answers for my Australia Classes

    I was out of the country for the last two weeks of March, delivering classes in Brisbane and Sydney, which were organized by WardyIT.  It was a great visit and there were 24 terrific students! As is sometimes (perhaps often?)  the case, there were questions posed that I couldn’t answer during class, so here are a couple of follow-up ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on April 4, 2012
  • 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 at the logging that was done for a different operation, and ended up generating some new ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 15, 2011
  • 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 times during index rebuild operations when run in ONLINE mode. He wanted to know if switching to ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on March 8, 2011
  • Geek City: Exploring the Transaction Log Structure

    As I mentioned last October, my PASS preconference seminar was a whole day about the transaction log. I told the attendees all kinds of things about the structure of the log, and told them about one of the best tools for exploring the structure: the command DBCC LOGINFO. This command is officially undocumented, but numerous bloggers have discussed ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 21, 2009
  • Geek City: 24 hours of SQL Server!

    I know, my Geek City posts are usually really technical, but I figured it’s only Geeks who are going to want a solid 24 hours of SQL Server presentations… so this post is dedicated to all the SQL Server Geeks out there! I will be presenting as part of 24 hours of PASS, on September 2. You can read about my session (“What’s Simple about Simple ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 13, 2009
  • Geek City: When is FULL Recovery not Really FULL Recovery

    You may think that having a database set to FULL Recovery Model means that your database can be fully recovered. The key word in that previous sentence is 'can'. It is possible to fully recovery a database in FULL recovery, or to restore it to an arbitrary point in time, or up to the point of a system failure, IF you have been a good DBA and you ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on November 30, 2008
  • Geek City: Reading the Transaction Log

    Sorry, I'm not actually going to tell you how to read the log. I'm just going to talk about it... and whether it's a good thing to be able to do or not, or whether it's an absolutely crucial feature that MS needs to provide for us immediately, in a hotfix, if not sooner. Forget about fixing bugs, I want to read the log because I forgot to set up a ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on August 23, 2008
Privacy Statement