SQL Server Forums Register Now and get your question answered!
Save Password Forgot your Password?   All Forums  SQL Server
2012 Forums  SQL Server Administration (2012)  nvarchar -
numeric vs alphanumeric  New Topic  Reply to Topic  Printer
Friendly Author Previous Topic Topic Next Topic    Starting
Member  8 Posts  Posted - 10/11/2013 :  13:26:27  Show Profile
 Reply with Quote  Hi Everybody!  This is a design/performance
question. There is an important field in our database everything
else revolves around. The data type of the field is
(nvarchar(50), null), and changing it is not an option.  We do
have a choice of the data input though. We can store numeric or
alphanumeric values in the filed. Would picking one over another
help with overall database/application performance?   Very
Important crosS Applying yaK Herder  52230 Posts
Posted - 10/11/2013 :  13:52:04  Show Profile  Reply with Quote
numeric may have slight upper hand over alphanumeric data. What
will data used for? is it some kind of unique iden