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. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.