Somewhat theoretical question, I suppose - which of these optimal to use when you're looking for all records in a given table that are not contained in another table?
LEFT JOIN TableB ON TableA.ColA = TableB.ColA
WHERE TableB.ColA IS NULL
WHERE NOT EXISTS(SELECT 1 FROM TableB WHERE TableA.ColA = TableB.ColA)
And, is there another solution which is more performant?