Tag Archives: transactions

  1. 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

  2. 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

  3. Negative session_ids

    2

    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

  4. Transactions: Who, What and Where

    Leave a comment

    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

  5. Transactions: What are they?

    4

    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

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

    4

    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

  7. Transactions: Rolling back part of a transaction.

    Leave a comment

    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

  8. Transactions: Rolling back a nested transaction

    Leave a comment

    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

Follow

Get every new post delivered to your Inbox.

Join 379 other followers