Category Archives: Transactions

  1. Bad Idea Cowboy Hat: BEGIN TRANSACTION; GO 1000;

    Leave a comment

    November 27, 2019 by Kenneth Fisher

    One of my favorite presentations is Revenge the SQL by Rob Volk (blog|twitter). It’s a demonstration of a lot of …
    Continue reading

  2. What is a distributed transaction?


    May 28, 2019 by Kenneth Fisher

    A while back I did a post defining a transaction. Basically, a transaction is a unit of work. The example …
    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. Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.


    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

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

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

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

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

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

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013