MsSQL – char and varchar comparison, storage concept
In Microsoft SQL Server, both CHAR and VARCHAR are used to store character string data, but they have some differences in terms of storage and behavior. Now, one important question would be, how these data stored on pages? Each page can stored only 8KB of data, so how changing the length of a varchar column…