![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)
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
![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)
The Easy way of changing Collation of all Database objects in SQL Server – Raymund Macaalay's Dev Blog
![sql server - Join tables via project names: if project name meets a specific criteria than replace it with another field - Stack Overflow sql server - Join tables via project names: if project name meets a specific criteria than replace it with another field - Stack Overflow](https://i.stack.imgur.com/kHGyH.png)
sql server - Join tables via project names: if project name meets a specific criteria than replace it with another field - Stack Overflow
![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)