Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do NULLs in MS SQL actually take up space?
Message
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Do NULLs in MS SQL actually take up space?
Miscellaneous
Thread ID:
00635479
Message ID:
00635479
Views:
51
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
Next
Reply
Map
View

Click here to load this message in the networking platform