Category Archives: System Functions and Stored Procedures

  1. Collation: Temporary objects and variables: Demonstration

    Leave a comment

    April 21, 2014 by Kenneth Fisher

    I had a recent run in with collation problems and it got me started reading about them. As I read …
    Continue reading

  2. Getting a query plan

    Leave a comment

    February 19, 2014 by Kenneth Fisher

    Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
    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. The “most_recent_sql_handle” column

    1

    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

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

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

  8. Finding active DTS packages

    Leave a comment

    November 27, 2013 by Kenneth Fisher

    DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS …
    Continue reading

  9. Finding the metadata for a query

    Leave a comment

    November 25, 2013 by Kenneth Fisher

    You know I occasionally find it interesting how I learn new things. I was running through a practice test for …
    Continue reading

  10. A better way to find missing indexes

    11

    November 11, 2013 by Kenneth Fisher

    I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 173 other followers