• I think the CASE in order by statements causes recompiles but I couldn't swear to it.

    I prefix stored procedures with usp and functions with fn.

    To be honest I have moved away from tbl and vw as prefixes for views and tables precisely because they are interchangeable.

    An MS example would be the syslogins view.

    I use Hungarian for variables and arguments within stored procedures but I don't bother for fields.  It is just being over-zealous.