title: SQL Server case insensitive collation
body: <p>What are the benefits/drawbacks of using a case insensitive collation in SQL Server (in terms of query performance)?</p>
  
  <p>I have a database that is currently using a case-insensitive collation, and I don't really like it. I would very much like to change it to case sensitive. What should I be aware of when changing the collation?</p>