[dba-SQLServer] How much storage

>Are you talking about one of the CHECKSUM functions?

hashbytes 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Thursday, May 24, 2007 9:42 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] How much storage

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?






_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com