Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Do NULLs in MS SQL actually take up space?
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Do NULLs in MS SQL actually take up space?
Divers
Thread ID:
00635479
Message ID:
00635479
Vues:
50
My partner and I are locked in an argument about NULLs. Does anyone out there know if they actually take up hard disk space as a table grows? For example, if I have a table with 100 rows and 10 fields that accept NULLs. If I fill in a value for only one field and leave the rest undefined, does MS SQL actually take up hard disk space set aside for the NULL's?

Thanks for any insight!

Jose
"Once in a while you get shown the light...
in the strangest of places if you look at it right"

Jerry
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform