• Cyclone (4/27/2011)


    Hi,

    We use SHA1 and store the result as Varbinary(MAX).

    Do you see any problems with this ?

    Thanks

    Yes, there is a problem: a varbinary(max) column can't be a key column in an index, so if you want to use your hash in an index you shouldn't use varbinary(max). That's the only problem I can think of.

    Tom