Why is fn_xe_file_target_read_file the worst SQL function?
I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but … reading the extended event file is so much pain.
I haven’t had a rant post in a while. There is a saying: “Anything before the word ‘but’ is ignored”. I love Extended Events, but … reading the extended event file is so much pain.
I originally planned this post just as an answer to DBA Stack Overflow question: How can I get the list of tables in all the stored procedure? After preparing a lab environment, I think it deserves its own blog post.
This month’s invitation is from Mala Mahadevan (b) asking us how we manage the database code. Since this is my passion project, I have a few basic tips to share.
This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).
No matter how hard Azure Data Studio (ADS) is pushed by Microsoft, most DBAs still use SQL Server Management Studio (SSMS). In this blog post, I’ll go through my initial setup and some tips and tricks.
I recently encountered an issue where an index rebuild set to wait_at_low_priority
ended up blocking an asynchronous statistics update.
This interaction led to a large blocking chain where queries were waiting on the async stats update and started to timeout.
In SQL Server, using the KILL
command to terminate a session results in an entry being logged in the error log.
This raises the question: Does the ALTER INDEX REBUILD
command with the WAIT_AT_LOW_PRIORITY
option also log its actions in the error log?