A simple typo can have serious consequences.
|SELECT * FROM t1 INNER JOIN t2 ON t1.c1=t1.c1|
Generates a ‘missing join predicate’ warning and a Cartesian product. In our case filling up 500GB TEMPDB space and a never ending query.
Some good advice, check your query plan for ‘missing join predicate’ warnings.