Born Day
I’m going to start this post off sort of like Friday’s post:
…Look, I really like EXISTS and NOT EXISTS. I do. They solve a lot of problems.
This post isn’t a criticism of them at all,
Blog
Performance Issues With EXISTS Queries
Dos Puntos
Look, I really like EXISTS and NOT EXISTS. I do. They solve a lot of problems.
This post isn’t a criticism of them at all, nor do I want you to stop using them. I would encourage you …
sp_WhoIsActive Version 12 Is Out!
Get’em Daddy
You know, you love it, you often wondered if it would ever get a new version!
…Someone JUST asked me yesterday if this has been updated recently. Thank you for sharing!
— Erin Stellato (@erinstellato) November 10, 2021
TRY_CAST And TRY_CONVERT Can Still Throw Errors
It Was Written
I was a bit surprised by this, because I thought the whole point of these new functions was to avoid errors like this.
SELECT
oops = TRY_CONVERT(uniqueidentifier, 1);
GO
SELECT
oops = TRY_CAST(1 AS uniqueidentifier);
GO
Both …
I’m Officially A Maintainer Of sp_WhoIsActive!
Busyness, Man
sp_WhoIsActive is probably one of the most famous utilities in SQL Server. To the point where when I see people using sp_who – sp_who4762, I immediately disqualify their ability as a DBA.
If you think that’s unfair, it’s …
The Right Way To Check For NULLs In SQL Server Queries
101ers
This is still one of the most common problems I see in queries.
People are terrified of NULLs. People are afraid to merge on freeways in Los Angeles.
What results is this endless stream of poorly performing queries, and …
Dealing With Wide Missing Index Requests
We’ve All Been There
You’re running a query that selects a lot of columns, and you get a missing index request.
For the sake of brevity, let’s say it’s a query like this:
SELECT
p.*
FROM dbo.Posts AS p
WHERE … Trying out the new premium-series Azure SQL Managed Instances
At Microsoft Ignite 2021, public preview for new “premium-series” hardware was announced for Azure SQL Managed Instances. There’s even a black friday sort of sale during this month where you can do testing on premium-series VMs without paying for the …
LOB Data, Recompile, And Too Much tempdb
Stumper
I got a very interesting issue about sp_HumanEvents recently, and I couldn’t quite figure out why things were going wonky.
The problem was that at some point when monitoring blocking long-term, something was taking up a whole lot of …
Updates To sp_HumanEvents, sp_QuickieStore, And More!
For Free!
Here’s some stuff I’ve been working on lately:
- Added an inline table valued function that strips characters from a string
- Added a script to create useful Alerts in SQL Server
- Added the recompile_cause column to the