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.