New SQL Rule - nonSargable queries - performance

Rules and Languages New rules / language support
1

Detect if nonSarable predicates are being using in join/where statements.

  • function(column) = something
  • column + column = something
  • column + value = something
  • column = @something or @something IS NULL
  • column like ‘%something%’
  • column = case when …