LyraLearn AI Learning Platform
Exams
← SQL Server Performance Tuning
Module 4

SARGability and Query Anti-Patterns

Rewriting queries so SQL Server can actually use your indexes.

4.1
"What SARGable Means"
10 min
4.2
"Functions on Columns and Date Ranges"
12 min
4.3
"Implicit Conversion: The .NET One"
14 min
4.4
"LIKE, SELECT *, and Column Bloat"
10 min
4.5
"Scalar UDFs and Row-by-Row Processing"
11 min
4.6
"The Catch-All Report Query"
14 min