How many plans are in the plan cache for a stored procedure?
It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...
2019-01-31
260 reads
It depends on where you’re looking and how many statements are in the stored procedure.
Let’s take a look at some...
2019-01-31
260 reads
I didn’t expect anything for free in index maintenance. After all, it takes a lot of CPU and transaction log...
2019-02-20 (first published: 2019-01-30)
2,398 reads
This post will cover the IN clause and another way to rewrite the same logic. I don’t intend to say...
2019-01-29
1,227 reads
I use sp_WhoIsActive a lot. I’m extremely grateful for Adam Machanic writing it. It has tons of options that let...
2019-01-28
3,154 reads
So far in this series, I’ve been focusing on the Sort operator. It’s pretty easy for demos since I can...
2019-01-25
468 reads
Did you know that you can compare two execution plans in SQL Server Management?
It’s really cool. I use it a...
2019-01-25
972 reads
This is the sequel to “It’s always parameter sniffing (part 1).” In that post, we identified the stored procedure, and...
2019-02-14 (first published: 2019-01-23)
2,497 reads
Proceed with caution, if you’re thinking of using query hints. This post will specifically cover min_grant_percent and max_grant_percent.
My opinion on...
2019-02-11 (first published: 2019-01-22)
6,449 reads
Part of query memory grants, part 4! This post will cover the wait type RESOURCE_SEMAPHORE briefly, but the focus is...
2019-01-21
531 reads
This is not a technical post! Just wanted to say that I set up a public email address for this...
2019-01-19
130 reads
Well, turns out code signing is pretty complex, so I’m writing this blog post...
By Steve Jones
For those that attended my talk at Denver Dev Days, here are the slides:...
By Steve Jones
As a part of my AI experiments, I decided to ask CoPilot to write...
Comments posted to this topic are about the item Software Flexibility (Avoiding the next...
Our IT department contacted me recently and asked if they should change the default...