Tag Archives: system functions
-
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 -
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 -
Connect suggestion to add included columns to sp_helpindex
1January 10, 2017 by Kenneth Fisher
I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the …
Continue reading -
Running code on the startup of SQL Server
1February 1, 2016 by Kenneth Fisher
Every now and again you need to run code when your instance starts up. For example you might want to …
Continue reading -
Finding the worst running query in a stored procedure
14September 10, 2015 by Kenneth Fisher
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something …
Continue reading -
Pulling data from the error log
8August 17, 2015 by Kenneth Fisher
The other day I was asked to pull a list of errors from the SQL Server log into a table …
Continue reading