Information générale
Catégorie:
Bases de données
Many thanks Naomi.
I thought as much but no harm in getting some expert opinions !!
Regards,
Gerard
>>I have a Data Warehouse type app which can load over a million records into a Data Adaptor and then does further processing (The main processing is doen by a third party product over which I have no control)
>>
>>A few questions:
>>1. I have all my char fieds set up as NVARCHAR(30) . If I change to VarChar(30) and change the SSMS setting to SET ANSI PADDING OFF , should this result in a smaller SQL table
>>
>>2. If I do 1 above, when the data is copied into a Table in memory using a dataadptor, is there still a saving in space (in memory) by using VarChar instead of NVARCHAR and by having the ANSI PADDING to off
>>
>>Tia
>>Gerard
>
>I believe the answer will be Yes on both questions.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement