Most people know that a LIKE predicate with only a trailing wildcard can usually use an index seek: SELECT p.Name FROM Production.Product AS p WHERE p.Name LIKE N 'D%' ; As the execution plan shows, SQL Server determines a covering range (which depends
Read More...