>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.