The issue I have is when we have multiple environments on the same SQL instance so we then have an environment suffix on each database name. This in itself isn't an issue as long as you only have one database per environment but this is rarely the case.
With multiple databases per environment we will have cross-database queries and its this scenario that causes us issues as this is when we need 3-part names.
William Strachan
supported this idea
·
The issue I have is when we have multiple environments on the same SQL instance so we then have an environment suffix on each database name. This in itself isn't an issue as long as you only have one database per environment but this is rarely the case.
With multiple databases per environment we will have cross-database queries and its this scenario that causes us issues as this is when we need 3-part names.