Null values.

Hi
my db allows too many null values...i can't do anything to make them not null as most of the fields can be NULL.
will it affect any performance on my server..and if yes then is there any method where we can avoid the degrading of performance causing by NULL values
2) doest NULL values really affect server performance
regard
sanjaNULL is handles like a value in SQL Server. so it doesn't affect performance
any differently compared to if you had an actual value in the column (except
for variable length columns where the NULL "value" only uses space in the
null map in the row layout compared to a real varchar value which is stored
in the row).
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"sanjay" <anonymous@.discussions.microsoft.com> wrote in message
news:5556A9CC-C2C3-4900-AB37-C81EB2723A7B@.microsoft.com...
> Hi,
> my db allows too many null values...i can't do anything to make them not
null as most of the fields can be NULL..
> will it affect any performance on my server..and if yes then is there any
method where we can avoid the degrading of performance causing by NULL
values.
> 2) doest NULL values really affect server performance.
> regards
> sanjay
>