CPU hash comp

SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , CHECKSUM(sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Checksum'

SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , BINARY_CHECKSUM(sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Binary Checksum'

SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , HASHBYTES('SHA', sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Hashbytes SHA'

SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , HASHBYTES('SHA1', sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Hashbytes SHA1'

SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , HASHBYTES('SHA2_256', sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Hashbytes SHA2_256'

SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , HASHBYTES('SHA2_512', sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Hashbytes SHA2_512'


SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , HASHBYTES('MD2', sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Hashbytes MD2'

SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , HASHBYTES('MD4', sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Hashbytes MD4'

SELECT  sod.SalesOrderID
        , sod.CarrierTrackingNumber
        , HASHBYTES('MD5', sod.CarrierTrackingNumber)
FROM Sales.SalesOrderDetail AS sod
PRINT 'Hashbytes MD5'

 SQL Server Execution Times:
   CPU time = 47 ms,  elapsed time = 481 ms.
Checksum

 SQL Server Execution Times:
   CPU time = 47 ms,  elapsed time = 536 ms.
Binary Checksum

 SQL Server Execution Times:
   CPU time = 125 ms,  elapsed time = 488 ms.
Hashbytes SHA

 SQL Server Execution Times:
   CPU time = 109 ms,  elapsed time = 497 ms.
Hashbytes SHA1

 SQL Server Execution Times:
   CPU time = 140 ms,  elapsed time = 544 ms.
Hashbytes SHA2_256

 SQL Server Execution Times:
   CPU time = 125 ms,  elapsed time = 514 ms.
Hashbytes SHA2_512

 SQL Server Execution Times:
   CPU time = 609 ms,  elapsed time = 802 ms.
Hashbytes MD2

 SQL Server Execution Times:
   CPU time = 78 ms,  elapsed time = 543 ms.
Hashbytes MD4

 SQL Server Execution Times:
   CPU time = 93 ms,  elapsed time = 467 ms.
Hashbytes MD5