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

Popular posts from this blog

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........