I like the ones where you only have to use a small amount of judgment and common sense, being a bit short in both departments myself

One of the most useful things about synonyms that we've found is that using a synonym stops SQL Server escalating to MSDTC (with its associated performance overhead) when you are...