Tag Archives: system views
-
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 -
It’s all just data.
2April 17, 2019 by Kenneth Fisher
Tables, stored procedures, views, logins, constraints, etc, etc. It’s all just data. In every database system I’ve ever worked on …
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 -
Master_Views: master_objects, master_tables, etc
1May 23, 2016 by Kenneth Fisher
There is a highly useful system view called sys.master_files. If you’ve never encountered it before it returns a list of …
Continue reading
SQL Studies 