• I haven't seen bad things with proc recompiles since the SQL2000 days. Every generation of SQLSERVER advances a little bit more rendering old hard won knowledge and techniques obsolete or of reduced relevance.

    SQL2016 gives us partition truncation thereby rendering partition switching old knowledge provided you have the relevant edition.

    We could almost do with a register of the old performance tricks that are now no longer relevant or even detrimental today