What exactly is the point of the loweredUsername, loweredEmail, loweredApplicationName, etc. columns in the aspnet_regsql created schema? I see that the lowered columns are in the clustered indexes while the non-lowered versions are not, but I don't understand why these values are sorted twice. Could someone explain the reasoning behind these seemingly duplicated columns? Why aren't the non-lowered columns good enough by themselves?
...
Go to the complete details ...