SQL SYNONYM and performance
sql-server, sql-server-2008, synonym
Solution
Here is a good SO thread on synonyms. Performance shouldn't be an issue on same server. I'm not sure cross server.
https://stackoverflow.com/questions/796791/sql-server-synonyms-tips-tricks
Problem
I have a requirement for some reporting and different environments, and the SQL `Synonym` would make a lot of sense with making our solution work. http://technet.microsoft.com/en-us/library/ms177544.aspx However, the operational support department doesn't like the idea, due to 'performace implications'. I can't see why there would be any performance degradation. But, has anyone had experience with SYNONYMs and medium sized databases (100gb) and performance issues? Should I be worried, or have Microsoft covered this, and whether you use a SYNONYM, or the fully qualified [Database].[schema].[tablename] in a query - is there any difference - performance wise?