1. Is there any script I can write to go through all of my tables to convert all of the nVarChar fields to VarChar?
2. I have found imcomplete info on this, can anyone find concrete: Do indexes on nVarchar perform slower than their VarChar siblings?
3. When I change the type of the field from nVarChar to VarChar, do I need to recreate the index that existed on that field?