Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
greznikov
Starting Member
1 Post |
 Posted - 2015-04-06 : 21:00:10
|
| I have a table with 8 fields most of them nvarchar and bigint. In an attempt to optimise the performance - I created the test table with the same number of fields, but using appropriate data types smallint and tinyint for integers and varchar for nvarchar fields.I then I copied data from old table to the new. The hypothesis was that smaller data types mean smaller indices and less memory footprint for cached data. However the table size that I got is only about 5% less than the original table in size. I expected about 30% space reduction...So the question is, am I just being ignorant in a way of the databases or something is wrong with the way I have things set up.Thank you for your help |
|
|
|
|
|
table doesn't change size with changing data types