I am working on a project where I need to be able to quickly tell if changes in data contained in a row have occurred. After playing around with HASHBYTES unsatisfactorily, I did some searches and came across this post: http://sqlserverplanet.com/data-warehouse/detecting-row-level-changes
This appears to be a decent method of discovering changes without the overhead of doing a full byte by byte compare.
