Excellent topic!

I just want to add one thing. If you use table variable or tmp table use all column names instead of just * in select statement.

Forexample:

Does not Work

select * from BLA_BLA

Use

select col1, col1,... from BLA_BLA