No, Not Really
But I did write a silly helper procedure for myself, that I figured I’d share here. I’m not putting it on GitHub right now (unless you all find it incredibly useful).
I often have multiple copies of …
Blog
The Optimizer Could Be Smarter About Constraints
Couldn’t We All
Let me ask you a question: If I told you that all the numbers in an integer column were either:
- > 0
- >= 1
You’d probably agree that the lower number you could possible see is 1.…
Enabling Optimize For Sequential Key
Sweetness, Shortness
Recently I blogged about last page contention solutions, and one thing I mentioned is that turning on OPTIMIZE_FOR_SEQUENTIAL_KEY doesn’t require you to rebuild an index. That’s awesome, because a whole lot of changes to indexes require you to …
Locking And Blocking Week: Recap
Sonic Deducer
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All you have to do …
Locking And Blocking Week: Weird Blocking
Dead and Alive
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All you have to …
Locking And Blocking Week: Tuning Begin Tran
Beginning OF The Tran
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All you have …
Locking And Blocking Week: Tuning Blocking With Indexes
All This And More
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All you have …
Locking And Blocking Week: Introduction
I Wanna Know What Lock Is
This week I’m giving away a sampling of the videos from my Locking and Blocking course.
If you want to see the entire thing, it’s available this week for just .99 cents.
All …
Updates To sp_HumanEvents and sp_PressureDetector
Ain’t Nothing To Do
I’ve made some changes to my scripts! Exciting. Sorta. Kinda.
sp_PressureDetector
Got a name change. The code hasn’t changed at all. I started getting annoyed by the formatting and the underscore between pressure and detector.
Now …