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