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.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 table doesn't change size with changing data types

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
   

- Advertisement -