Category 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. Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

    1

    January 29, 2014 by Kenneth Fisher

    I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I …
    Continue reading

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

  5. Transactions: Who, What and Where

    1

    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

  6. Transactions: What are they?

    6

    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

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

  8. Transactions: Rolling back part of a transaction.

    1

    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

  9. Transactions: Rolling back a nested transaction

    5

    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,598 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013