By default SQL server queries are case insensitive (and other databases also allow case insensitive search or even default to that) so i dont understand the idea of maintaining separate normalized columns. Why Microsoft is spreading such bad design? Keep it simple, stupid!

Or go and ask SQL developers about how the indexes work before you start fixing what ain't broke.