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? Select Columns,… from Table where Name like ‘%String%’ Reading the great book SQL Server 2012 Internals, on […]