COLLATE SQL_Latin1_General_CP1_CI_AI – Fabricio Lima | Consultoria e Treinamento SQL Server

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

8 de fevereiro de 20178 de fevereiro de 2017Fabrício LimaSem categoria

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?

Select Columns,...
from Table
where Name like '%String%'

Select Columns,...

from Table

where Name like '%String%'

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