Skip to content
SQL Server CLR that implements hashing for 4 different algorithms that does not have SQL Server's 8000 byte input limitation.
C#
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
GetHashHybrid.function.sql
HashUtil.cs
LICENSE
README.md
benchmark-over8000.script.sql
benchmark-under8000.script.sql

README.md

sql-hashing-clr

SQL Server CLR that implements hashing for 4 different algorithms that does not have SQL Server's 8000 byte input limitation. This project also includes a function that uses both the HASHBYTES() function and this CLR based on the length of the input.

###HashUtil.cs The actual CLR class.

###GetHashHybrid.function.sql The function that either calls SQL Server's HASHBYTES() function or the CLR based on the length of the input.

###benchmark-under8000.script.sql This script evaluates the CPU usage of HASHBYTES(), the CLR, the hybrid function, and fn_repl_hash_binary using inputs under 8000 bytes. Detailed information can be found in the comments of the script.

###benchmark-over8000.script.sql This script evaluates the CPU usage of the CLR, the hybrid function, and fn_repl_hash_binary using inputes both under and over 8000 bytes. Detailed information can be found in the comments of the script.

You can’t perform that action at this time.