March 2010

Earlier today I was discussing methods you can use to differences in data sets between two tables or views.  My colleague was discussing the usual method SELECT columName(s) FROM table1 t1 (READCOMMITTED) LEFT JOIN table2 (READCOMMITTED) ON t1.sharedKey = t2.sharedKey WHERE t2.sharedKey IS NULL While this is a perfectly cromulent way of finding out what…

Read More UNION, INTERSECT, and EXCEPT