Category Archives: System Functions and Stored Procedures

  1. DBA Myths: The system sessions are the ones with a session_id 50 or less

    Leave a comment

    November 18, 2019 by Kenneth Fisher

    Anecdotally any session_id that’s 50 or less is going to be a system session and anything over 50 will be …
    Continue reading

  2. DMV with SQL Server Service info (including the service accounts)

    5

    September 12, 2019 by Kenneth Fisher

    I recently found this DMV and couldn’t wait to share. sys.dm_server_services What’s so great about it? For each service for …
    Continue reading

  3. When were the statistics last updated and how many rows were sampled?

    Leave a comment

    September 4, 2019 by Kenneth Fisher

    TL;DR; Final query is at the bottom. Every now and again (particularly when someone is having performance problems) I’ll get …
    Continue reading

  4. Constructing a datetime from an integer date and an integer time.

    4

    August 15, 2019 by Kenneth Fisher

    Occasionally I’ve seen date and time stored separately as integers. This had some practical applications back before we had date …
    Continue reading

  5. SQL Homework – June 2019 – Property functions

    Leave a comment

    June 3, 2019 by Kenneth Fisher

    Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This …
    Continue reading

  6. Highlighting sp_spaceused

    Leave a comment

    October 15, 2018 by Kenneth Fisher

    I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick …
    Continue reading

  7. What are my permissions?

    1

    August 16, 2018 by Kenneth Fisher

    Permissions are a common concern. One of the most frequent requests I get is I need X, Y and Z …
    Continue reading

  8. Exploring system tables, views, SPs etc

    Leave a comment

    April 18, 2018 by Kenneth Fisher

    I wanted to spend a few minutes highlighting a couple of important tools for figuring out what information you have …
    Continue reading

  9. sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)

    1

    October 11, 2017 by Kenneth Fisher

    I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into …
    Continue reading

  10. What is the system_health extended events session?

    3

    July 5, 2017 by Kenneth Fisher

    Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about …
    Continue reading

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

Join 3,084 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013