Supposedly the 'primary key' constraint has the same effect as the 'unique clustered' one. But I have found that using the latter leads to a different execution plan (and much improved execution time) from the former.
Either way, if you're going to insert a lot of records into a temp table or table var, put a unique clustered constraint/index on it by some method.
Anti-nuisance lawsuit warning: The purpose of these notes is to remind me, Zoegond, of stuff or to help me work stuff out. They may contain mistakes.
Quick
- ($a, $b....) = unpack("A2A7...", $packed)
- push( array, list )
