I've recently discovered a great use of synonyms. My company won't refresh UAT from production and UAT is years out of date. This has forced me to develop in production (all my queries would return zero rows in UAT). I've used synonyms to write to "temporary test" tables in production. Then, when the test tables are signed off, i flip the synonyms to the production tables and the procs are all good to go.