What is smaller when saving to SQL database?
when saving blank column sql database, of these 2 options uses least amount of space on hard drive?
null or ""
would there benefit using 1 on other?
might silly question when databases large think can make difference.
thanks not laughing hard.
dave
ideally, should using null
"" value - though not contain value still value
where null undefined , has no value.
i not have excat metrics storage wise null better data type
if of data in column null, can make column sparse--it have better savings in storage
refer this
http://weblogs.sqlteam.com/mladenp/archive/2007/09/06/how_does_sql_server_really_store_null-s.aspx
refer links in post(3rd reply)
http://www.sqlservercentral.com/forums/topic585323-80-1.aspx
hope helps!!
SQL Server > Getting started with SQL Server
Comments
Post a Comment