» Performance (RSS)
Sorry, but there are no more tags available to filter with.
Most people know that a LIKE predicate with only a trailing wildcard can usually use an index seek: SELECT
FROM Production.Product AS p
p.Name LIKE N'D%';
As the execution plan shows, SQL Server determines a covering range (which depends on the collation), seeks the ...