![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
![sql server - What are the rules for using COLLATE in a query? - Database Administrators Stack Exchange sql server - What are the rules for using COLLATE in a query? - Database Administrators Stack Exchange](https://i.stack.imgur.com/BCp53.jpg)
sql server - What are the rules for using COLLATE in a query? - Database Administrators Stack Exchange
![sql server - SQL Cannot resolve the collation conflict between "Arabic_100_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation - Stack Overflow sql server - SQL Cannot resolve the collation conflict between "Arabic_100_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation - Stack Overflow](https://i.stack.imgur.com/7E7i0.png)
sql server - SQL Cannot resolve the collation conflict between "Arabic_100_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation - Stack Overflow
![The Easy way of changing Collation of all Database objects in SQL Server – Raymund Macaalay's Dev Blog The Easy way of changing Collation of all Database objects in SQL Server – Raymund Macaalay's Dev Blog](http://www.macaalay.com/wp-content/uploads/2011/12/restore-default.png)