[dba-SQLServer] How much storage

Stuart McLachlan stuart at lexacorp.com.pg
Thu May 24 20:41:55 CDT 2007


On 24 May 2007 at 21:23, jwcolby wrote:

> How much storage is used for varbinary?  I am looking at using the hash
> function of SQL Server (built in to SQL Server 2005 now), and it returns
> something like 120-180 "somethings", it is defined as varbinary(8000)
> maximum.  AFAICT it is a fixed width that varies depending on the hash
> algorithm.  Is it returning an array of characters with 120-180 elements?
> Is binary (or varbinary) defined in bits of a 32 bit word?  Is each binary
> digit stored as a single position in a character?

varBinary = Variable length Binary data.  It's just a string of bytes 
and it uses as much as it needs to store whatever chunk of data is 
put in it.

Are you talking about one of the CHECKSUM functions?









More information about the dba-SQLServer mailing list