My favourite example of this is that you have to recompile program when a used table schema changes, otherwise it will crash.

edit: Just realized that it's more platform specific than site specific.