DSXchange

hi,

what is difference between hash and modules partation techniques please give me guide on this

Thanks,
Srinivas

Modulus is a keyed partioning method where rows are evenly distributed according to the values in one integer key column i.e. partition = MOD(key_value / @NUMPARTITIONS) This is quicker than hash which uses cyclic redundancy check

When's the interview?