General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Hi Fabio,
>
>How about SQL Server? Will defaulting a TEXT field to an empty string (real value) take up more or less space than defaulting it to Null (no value) in SQL Server.
>
>
>Ben
>
On MS SQL NULLs are very optimized.
Practically they do not occupy space.
MS SQL allocation it is not linear,
but with a simple table with 1 Text field
show a 10/1 ratio for ''/NULL.
Fabio
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only