Tag Archives: transactions

  1. Blocking and deadlocking on purpose

    Leave a comment

    July 1, 2015 by Kenneth Fisher

    Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling …
    Continue reading

  2. Playing with the log – Before the first full backup


    October 29, 2014 by Kenneth Fisher

    The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the …
    Continue reading

  3. Transactions: What commands aren’t allowed?

    Leave a comment

    February 5, 2014 by Kenneth Fisher

    Transactions are great tools that every DBA and developer should learn how to use. Unfortunately not everything can be put …
    Continue reading

  4. Transactions: Creating a single restore point across multiple databases.

    Leave a comment

    February 3, 2014 by Kenneth Fisher

    This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple …
    Continue reading

  5. Negative session_ids


    January 27, 2014 by Kenneth Fisher

    I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
    Continue reading

  6. Transactions: Who, What and Where


    January 20, 2014 by Kenneth Fisher

    Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I …
    Continue reading

  7. Transactions: What are they?


    January 8, 2014 by Kenneth Fisher

    I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I …
    Continue reading

  8. Transactions: Rolling back a transaction inside a stored procedure.


    January 6, 2014 by Kenneth Fisher

    So over the last couple of posts I’ve talked about the fact that the ROLLBACK command will roll back an …
    Continue reading

  9. Transactions: Rolling back part of a transaction.


    December 19, 2013 by Kenneth Fisher

    In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way …
    Continue reading

  10. Transactions: Rolling back a nested transaction


    December 17, 2013 by Kenneth Fisher

    Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID). …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,580 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013