THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Conversions » Seeks   (RSS)
  • Dynamic Seeks and Hidden Implicit Conversions

    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 on the collation), seeks the ...
    Posted to Page Free Space (Weblog) by Paul White on January 17, 2012
Privacy Statement