Leakin’
There are some helper views and functions that I use in a few presentations, and I figured it was time to stick them on The GitHub so I don’t have to package them up and remember to keep changes …
Blog
More Dates For Online Training: July 10th and 24th
Missing Persons
If you missed out on my online class, I’m offering two more dates for it in July.
You can catch all the goodness of Premium Performance Tuning on July 10th and 24th.
In this class, I’ll teach you …
More Local Variable Nonsense: ORDER BY
Local Disasters
I see this kind of pattern a lot in paging queries where people are doing everything in their power to avoid writing dynamic SQL for some reason.
It’s almost as if an entire internet worth of SQL Server …
More Local Variable Nonsense: TOP
Number One
In case you missed it for some reason, check out this post of mine about local variables. Though it’s hard to imagine how you missed it, since it’s the single most important blog post ever written, even …
More Dates For Online Training: July 10th and 24th
Missing Persons
If you missed out on my online class, I’m offering two more dates for it in July.
You can catch all the goodness of Premium Performance Tuning on July 10th and 24th.
In this class, I’ll teach you …
Lookups Are Just Joins With No Choices
Such Optimize
At this point in your life, you’ve probably seen, and perhaps even struggled with how to fix a key lookup that was causing you some grief.
This post isn’t going to go terribly deep into anything, but I …
LOB Data And Weird Locks
Working On It
I’ve been re-working a lot of the demos in a presentation that I’m working on called Index Internals That Matter For Performance, because after a first walk through them, I had a lot of realizations about …
Experiment With Table Variable Deferred Compilation Without SQL Server 2019
I Have A Secret To Tell You
If you haven’t heard by now, Table Variables have some ✌features✌ that can cause performance issues pretty generally in SQL Server.
- One row estimates unless you recompile (or that darn trace flag)
- No
More Dates For Online Training: July 10th and 24th
Missing Persons
If you missed out on my online class, I’m offering two more dates for it in July.
You can catch all the goodness of Premium Performance Tuning on July 10th and 24th.
In this class, I’ll teach you …
Adopting An Anti-Harassment Policy For Online Training
Don’t Be A
This isn’t a technical post, but give it a read anyway.
With a lot of events going online, including yours truly (I’m teaching a live class today!), those events need to stay committed to making sure people …