T-SQL Analyzer

# SQL Server Rule: SRP0002 | | | |----|----| | Assembly | SqlServer.Rules | | Namespace | SqlServer.Rules.Performance | | Class | AvoidEndsWithOrContainsRule | ## Rule Information | | | |----|----| | Id | SRP0002 | | Friendly Name | Unanchored string pattern | | Category | Performance | | Ignorable | true | | Applicable Types | Procedure | | | Scalar Function | | | Table Valued Function | | | View | ## Description Try to avoid using patterns that start with '%' when using the LIKE keyword if possible. (Sargable) ## Summary Avoid using patterns that start with '%' with the LIKE keyword (Sargeable) ### Remarks This rule checks for usage of wildcard characters at the beginning of a word while searching using the LIKE keyword. Usage of wildcard characters at the beginning of a LIKE pattern results in an index scan, which defeats the purpose of an index. _{^{Generated by a tool}}