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 |
|
gvd
Starting Member
21 Posts |
 Posted - 2005-09-17 : 01:11:10
|
Hello guys, i just wanted to find out what effect or toll that null values have on a database as against empty string i.e."''". Am askin cos i have a Db with many null values, and its extremely large. I was wondering if i will gain some space and notice some added performance gain by replacing all the null values with empty string "''" Thanx people, will b xpectin ur reply soonest |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-17 : 01:40:25
|
| Do you know that the value for those columns is a blank string? Or is the value unknown?If the latter, and you replace NULLs with blank strings, how will you be able to tell a genuine, known, blank string value from another record that actually has an unknown value?And what would you do about date and numeric columns that don't allow blank strings? Come up with some arbitrary value instead of NULL?Decidedly dangerous policy IMHO!OTOH if you have a column that currently allows NULLs but every single row has a non-null value, then it would be worth considering changing it to NOT NULLKristen |
 |
|
|
|
|
|
Null Values in Database