TSQL

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.

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.

I’m using SQL and KQL to solve Advent of Code puzzles this year. It’s an annual event in which participants solve a series of increasingly complex challenges.

This blog post will show you how to find and affect the default Extended event file target’s path.

I write about how to triage the Scalar UDFs in your environment. This is probably the final article in this series.

In this longest post in the series, I’ll show you how you can fix the problems with Scalar UDFs.

Continuing the series, we’ll examine how Scalar functions are terrible for performance.