Category Archives: System Functions and Stored Procedures
-
DBA Myths: The system sessions are the ones with a session_id 50 or less
Leave a commentNovember 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 -
DMV with SQL Server Service info (including the service accounts)
5September 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 -
When were the statistics last updated and how many rows were sampled?
1September 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 -
Constructing a datetime from an integer date and an integer time.
6August 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 -
SQL Homework – June 2019 – Property functions
Leave a commentJune 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 -
Highlighting sp_spaceused
1October 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 -
What are my permissions?
1August 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 -
Exploring system tables, views, SPs etc
Leave a commentApril 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 -
sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)
2October 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 -
What is the system_health extended events session?
4July 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