Loading…

Improve the performance of a query that uses ” like ‘%String%’ ” changing only the collation

Hi Folks, In this blog post, I will give you a very useful tip to improve the performance of a query that uses ” like ‘%String%’ “. How often do you have to use a query like this?

Reading the great book SQL Server 2012 Internals, on page 230, we have: “Another case where […]