Lawrence Moore (9/12/2014)

---

I played around with synonyms for a while, then came to the conclusion that they really offer no advantages over views.

So can someone explain how a synonym is...

Yes, it's why you have to keep pace with the requirements that the system...

What would life be...

nharris (9/12/2014)

---

I would be concerned with the example that "hides" the fact that a table is actually on a different server. That could cause huge performance issues if the real...

kenambrose (9/11/2014)

---

I can't recall a single environment in the past 10 years I have worked in that allowed OPENQUERY. It was always considered a no no due to...

As Mighty pointed out, there no situations where synonyms are an unavoidable necessity.

I myself come from a different environment, which the Oracle side of data storage. 🙂 In Oracle, synonyms...

I agree it's a bit of a stretch. 🙂

My point was that indexing might have different purposes, optimizing search operations being just ONE of them.

The indexed FKs have nothing to do with performance; increased performance MIGHT be a side-effect, but - as you point out - it might as well not be such an...