Information générale
Catégorie:
Bases de données
Titre:
Ow to conserve space
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
Suivant
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