Good ideas presented in the article, just one thing I'd like to point out.  In Example 3, you say to use GetDate() in a UDF.  That's not possible since GetDate() is non-deterministic.  Only deterministic functions can be used in a UDF.  The best practice would be to use CURRENT_TIMESTAMP instead of GetDate().  CURRENT_TIMESTAMP is ANSI standard, so it's more portable and you can plan on it being around for a long while.  There are no guarantees with GetDate().