gharris_35 (2/9/2009)
noeld (2/9/2009)
You must change those that you can to VARCHAR it will reduce the width by 2
Unable to do so as the system needs to support multibyte character strings.
You should also consider removing the columns not needed
There are probably more columns that can be removed.
You should probably normalize the design a bit.
I am actually not responsible for the "design" as this is part of a CRM system therefore I do believe data mining was envisaged. Also this system is from a third party so normalization is not possible. I.e. I could break the system by normalizing the data.
The other thing that I forgot to mention was that the database was migrated from SQL Server 2000.
Graham Harris
I don't really understand why are you saying that you CAN drop columns and not normalize it but that is another thread 😉
Anyway you can use the query I posted:
select sum( character_octet_length)
from information_schema.columns
where table_name ='LEAD'
and data_type not in('ntext','text','image' )
and character_maximum_length is not null
So that you get an idea of how far are you from the "goal" as you go dropping "character" columns.
For non character you will need to include their sizes depending on the datatype