Still some developer use improper data type when designing database.

Storage in very important part in RDBMS that’s why Microsoft provide various data type to solve this problem. OLTP and OLAP database behave same when they processing a query. It will effect overall performance and storage. Finally it will require more infrastructure cost. Varchar vs Nvarchar: Choice for Unicode / multilingual  data If you want …

Still some developer use improper data type when designing database. Read More »