Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag hash Rss

   Items 1 to 4 of 4   
 

JOIN HINTS

By Uwe Ricken 2016/01/14 | Category: query optimization
Rating: (not yet rated) |  Discuss |   Briefcase | 1,657 reads

Using hash values in SSIS to determine when to insert or update rows

A common method to detect if a row has changed is to compare hashes. Integration Services itself doesn’t have a hash implementation, so in this tip I’ll show how you can implement a hash detection mechanism using a script component, as an alternative to the pure T-SQL solution.  Read more...
By Additional Articles 2014/02/25 | Source: MSSQLTips.com | Category: hash
Rating: (not yet rated)  Rate this |   Briefcase | 2,898 reads

An Implementation of the FNV1a Hash Algorithm for SQL Server

Three CLR-resident functions for 16-, 32-, and 64-bit FNV1a hashing  Read more...
By Bret Lowery 2012/02/20 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 4,310 reads

Comparing a hash

By alastors 2010/02/01 | Category: comparing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,397 reads
   Items 1 to 4 of 4   
 
Tags
c# (1)    
comparing (1)    
execution plans (1)    
fnv (1)    
fnv1 (1)    
fnv1a (1)    
function (1)    
functions (1)    
hashing (1)    
integration services (ssis) (1)    
loop (1)    
merge (1)    
query optimization (1)    
query optimizer (1)    
replicate (1)    
sqlclr (1)    
t-sql (1)