Monthly Archives: January 2014

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

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

  3. The “most_recent_sql_handle” column


    January 22, 2014 by Kenneth Fisher

    While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in …
    Continue reading

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

  5. sp_SrvPermissions & sp_DBPermissions V4.0

    Leave a comment

    January 15, 2014 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
    Continue reading

  6. Guid vs Identity columns (Ints)


    January 13, 2014 by Kenneth Fisher

    I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary …
    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. Happy new year!


    January 1, 2014 by Kenneth Fisher

    Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had …
    Continue reading

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013