Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Do NULLs in MS SQL actually take up space?
Message
De
21/03/2002 11:06:33
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00635479
Message ID:
00635532
Vues:
28
Which version of SQL Server and are the columns varying or not?

-Mike

>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
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform