I have two tables that are identical and hold the same rows of data.
one uses a varchar(255) for every column of the table, the other is correctly typed for each column (using date, int, decimal etc.).
Using Management Studio's properties window, I can see that the table that stores all data as varchar is far smaller, which is not what I expected to see. My understanding was that an int would only use 4 bytes of space and therefore use much less space than an int stored as a varchar.
What should I look for to understand what is happening here? Both tables have a primary key on an int column and no other indexes. For testing purposes they have been populated with identical datasets from the same source query.