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
SQL Server Consulting, Education, and Training
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
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 …
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from …
If you landed here from Brent’s weekly links, use this link to get my training for 90% off.
The access is for life, but this coupon code isn’t! Get it while it lasts.
Discount applies at checkout, and you …
Okay look, you probably should update stats. At least when you do it, you have some control over the situation.
If you let SQL Server get up to its own devices, you might become quite surprised.…
Blocking sucks. SQL Server should have used an optimistic isolation level by default.
Sure, writers would still block each other, but think of all the time people could have saved not explaining NOLOCK hints.
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available …
In the last post, we looked at how to see if your query is misbehaving, or if things are running normally.
Note that I didn’t say “good” here. Just normal.
For you.
Look, it’s impressive enough that sp_WhoIsActive works as well as it does. Most people who’ve been using it for a while are familiar with using @get_plans to retrieve query plans, or @get_locks to see locking information. I’m gonna spend …
But when I do, it’s usually to tell people they should use RCSI, and then disappear in a cloud of smoke.
Recently I was thinking about lock promotion, because that’s what happens when I …