Varchar

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  September 25, 2008 at 8:04 am

  #191415

  Hello,

  Varchar value uses only one byte to store one character,If I have many columns within select tables are allowing NULL values (as a default). No values are entered and because the data types are varchar(X), can SQL server reserve a great deal of space within the database?

  Thank you

• Jerry Hung

  SSChampion

  Points: 12968

  More actions

  September 25, 2008 at 9:51 am

  #877119

  Probably a partial reason for SPARSE column in SQL 2008

  It's meant to be used for a column where MOST values are NULL

  SPARSE column, NULL will not take up any space

  SQLServerNewbieMCITP: Database Administrator SQL Server 2005