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!
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.