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 » Performance » Conversions » Seeks   (RSS)
Sorry, but there are no more tags available to filter with.
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement