Home Forums SQL Server 2014 Development - SQL Server 2014 Trying to use the HASHBYTES of a nvarcar(Max) RE: Trying to use the HASHBYTES of a nvarcar(Max)

  • July 30, 2016 at 7:32 am

    #1892745

    For several reasons I'm not to keen on a calculated column for the hashes, performance being an obvious one, I rather hash the content on the insert.

    SO VERY TRUE!! There are so many things I see clients do on SQL Server that should be done elsewhere!! It is a precious, VERY EXPENSIVE, collection of limited resources (RAM, IO, CPU, LOCKS, IO, LATCHES, IO, etc, etc) that when constrained or overwhelmed cause performance issues.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service