good article; just a quick note on the insert statement; SQL 2008 allows multiple values in one INSERT statement and is quite faster than an "INSERT... SELECT... UNION ALL":

INSERT INTO Table ( Column1, Column2 ) VALUES

( Value1, Value2 ), ( Value1, Value2 )...