SQL: Compare values or rows

In SQL, if you need to check if two values (or rows) are different, the BINARY_CHECKSUM function is very useful and fast:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_1mi1.asp