Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql777
Constraint Violating Yak Guru
314 Posts |
 Posted - 2005-11-24 : 15:05:32
|
| So I have this table with 4 NTEXT columns, 2 of the NTEXT columns will 50% of the time have no data in them.With the goal to save disk space, would it make a difference if they column had a default value of NULL versus '' ?Personally i'd want to have '' since it will save me the headache of checking for NULL values etc.TIA |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2005-11-24 : 16:35:17
|
| TEXT and NTEXT are not even stored in the table, so I would say that there would be little difference in terms of space used. |
 |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2005-11-24 : 16:36:50
|
| It has been mentioned that an empty string in TEXT (NTEXT) column causes more disk space than a NULL.You have a couple of options...a) Look at the TEXT in ROW option.b) Use a NULL place holder and then create a view that converts the NULLs to an empty string. Ensure that all clients use this view.DavidMIntelligent Design is NOT science.A front-end is something that tries to violate a back-end. |
|
|
|
|
|
|
NTEXT default to NULL or '' ?