I talk about archive tables in SQL Server and how to improve the process using table partitioning.

For T-SQL Tuesday #200, I offer up one thing that always raises my eyebrows during a code review: the RIGHT OUTER JOIN.