Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Do NULLs in MS SQL actually take up space?
Message
From
21/03/2002 11:06:33
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00635479
Message ID:
00635532
Views:
29
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform