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.

    Leave a comment

    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

    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

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

  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.

    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

  9. Transactions: Rolling back a nested transaction

    2

    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 527 other followers