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, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.