Performance Tuning
When Does SARGability Matter Most?
!erehT iH
I know what you’re thinking. Another post about how you should just never do this one thing and all your queries will magically end up faster.
Just watch the video.
For more reading, check out these posts:
Free, 3× a week
Get my new posts by email
Three posts a week, plus a Monday roundup of the best database news from around the web.
Aaaand bookmarked…Thanks! I find myself becoming a bit of a SQL developer as we don’t have proper ones here (I’m more traditional DBA) so brushing up on my index design. I’ve sent it to them, so hopefully they’ll listen and take it to heart.
Gaby — hardly anyone listens. It’s nice job security.
Thanks!
Loved that this was a video, very easy to digest. It would have been a very long article and despite good intentions, I sometimes get a bit lost trying to keep track of the wordier posts.
I find videos much easier to process, and even better – much easier to share with others (and this will be shared). Thanks Erik
Thanks, Katy. Yeah, I’m going to start doing more videos in place of blog posts when possible.
Great video Erik! I am just wondering: Is there anything special about the predicate 1 = (SELECT 1) so that you put it in the first relatively simple demo query?
Martin – check this out: https://www.brentozar.com/archive/2018/05/behind-every-trivial-plan-is-a-good-demo/
Nicely done! This helped me with an area I hadn’t delved into much before.