SARGability Week: Wrap Up

One Metric Week

This went on a bit longer than I thought it would, but to someone who tries to blog five days a week, that’s a good thing.

While this isn’t the most glamorous subject in the world, it seems it’s still a necessary one to write about. I don’t quite know how to feel about that, as I’ve read and written about it many times over the past 10 or so years.

• SARGability Week: What Is It, Anyway?
• SARGability Week: Using Computed Columns To Fix Non-SARGable Queries
• SARGability Week: Using Temp Tables To Fix Non-SARGable Queries
• SARGability Week: Using Index Column Order To Fix Non-SARGable Queries
• SARGability Week: Using Dynamic SQL To Fix Non-SARGable Queries
• SARGability Week: Max Data Type Columns And Predicates Aren’t SARGable
• SARGability Week: Rewriting Scalar User Defined Functions To Make Them SARGable
• SARGability Week: Using Indexed Views To Make Predicates SARGable
• SARGability Week: Why Implicit Conversions Aren’t SARGable

Thanks for reading!

Going Further

If this is the kind of SQL Server stuff you love learning about: these days I have AI do the annoying stuff for me. My new video course teaches you to work the same way, and I teach whole teams in a one-day workshop. Someone still has to know enough SQL Server to keep the robots in check, and that’s what my training is for.