JaguarJag
15-02-2007, 06:06 AM
I know what's the difference between the (empty string) and Null
but how both are stored in the database?!
i want to know which is taking more space
is it pointers and the blank point to empty field and null does not have a pointer?
or do we store something physically for each case?
any ideas.
i got this reply about performance
If you permit a column to allow nulls, then SQL Server has to decode a special bitmap for each row which tells SQL Server as to whether the value is or is not a null.
This introduces an overhead for SQL Server.
which i doubt its right.
any idea about it too?
many thanks
but how both are stored in the database?!
i want to know which is taking more space
is it pointers and the blank point to empty field and null does not have a pointer?
or do we store something physically for each case?
any ideas.
i got this reply about performance
If you permit a column to allow nulls, then SQL Server has to decode a special bitmap for each row which tells SQL Server as to whether the value is or is not a null.
This introduces an overhead for SQL Server.
which i doubt its right.
any idea about it too?
many thanks