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.