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

SQL Server PSProvider SQL Server Authentication

BIT Version

How to calculate the delta size while diffing the files in TeamFoundationServer ?