![Improve the performance of a query that uses ” like '%String%' ” changing only the collation – Fabricio Lima | Consultoria e Treinamento SQL Server Improve the performance of a query that uses ” like '%String%' ” changing only the collation – Fabricio Lima | Consultoria e Treinamento SQL Server](https://www.fabriciolima.net/wp-content/uploads/2017/02/PostCollationTimeAfter.png)
Improve the performance of a query that uses ” like '%String%' ” changing only the collation – Fabricio Lima | Consultoria e Treinamento SQL Server
![sql server - index not being used due to different collations - is there any work around? - Database Administrators Stack Exchange sql server - index not being used due to different collations - is there any work around? - Database Administrators Stack Exchange](https://i.stack.imgur.com/egryu.jpg)
sql server - index not being used due to different collations - is there any work around? - Database Administrators Stack Exchange
![The Data School - Snowflake (SQL): Inputting Tables from Prep, REGEXP_REPLACE, COLLATE(), and Exporting as CSV/TSV The Data School - Snowflake (SQL): Inputting Tables from Prep, REGEXP_REPLACE, COLLATE(), and Exporting as CSV/TSV](https://www.thedataschool.co.uk/content/images/2021/06/Solution.png)
The Data School - Snowflake (SQL): Inputting Tables from Prep, REGEXP_REPLACE, COLLATE(), and Exporting as CSV/TSV
![sql server - index not being used due to different collations - is there any work around? - Database Administrators Stack Exchange sql server - index not being used due to different collations - is there any work around? - Database Administrators Stack Exchange](https://i.stack.imgur.com/bXSDl.jpg)