Call now: (800) 766-1884  


 SQL Server Tips
 SQL Server Training

 SQL Server Consulting
 SQL Server Support
 SQL Server Remote DBA

 SQL Server Scripts
 Scripts Menu




  SQL Server Tips by Gama and Naughter

MD4, MD5 and SHA Hash Algorithm

MD4 is a hash function designed by Ron Rivest and published in RFC 1186 in 1990. The MD4 algorithm produces a hash value which is 128 bits or 16 bytes in size. After the algorithm was first introduced it was successfully crypto analyzed. Details of the XP implementation for MD4 is described later in the section on MD5

MD5 Hash Algorithm

Ron Rivest developed MD5 in response to the problems discovered in MD4. As with MD4, it produces a 128-bit hash value. It is described in RFC 1321.

SHA Hash Algorithm

NIST, along with the National Security Agency (NSA), designed the Secure Hash Algorithm for use with the Digital Signal Standard. The standard SHA1 algorithm produces a 160-bit or 20-byte hash value. Other versions of SHA allow for even longer key lengths namely SHA-256, SHA-384 and SHA-512. The increased size of the SHA1 hash value compared to MD5 means that the chance of collision between hash values is much reduced. The longer key length versions of SHA are only available on Windows 2003.

The above book excerpt is from:

Super SQL Server Systems
Turbocharge Database Performance with C++ External Procedures

ISBN: 0-9761573-2-2
Joseph Gama, P. J. Naughter  


Burleson Consulting Remote DB Administration







Burleson is the America's Team

Note: The pages on this site were created as a support and training reference for use by our staff of DBA consultants.  If you find it confusing, please exit this page.

Errata?  SQL Server technology is changing and we strive to update our SQL Server support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:and include the URL for the page.

Burleson Consulting
SQL Server database support


Copyright 1996 -  2013 by Vaaltech Web Services. All rights reserved.

Hit Counter