September 10, 2013 at 1:32 pm
Our lead wants me to maintain two different version of VIEW
for DEV and PROD.
We're building custom reports for Financial Application system
and we're not allowed to query PROD Db directly, only through views.
In DEV it is "SELECT * FROM EU1_Transform.dbo.MapGLAccount INNER JOIN EU1_Transform.dbo.iScalaCompanies ...."
In PROD he wants me to have this:
"SELECT * FROM LINKEDSERVER.dbo.EU1_Transform.dbo.MapGLAccount INNER JOIN LINKEDSERVER.EU1_Transform.dbo.iScalaCompanies ...."
I'm not sure inner joins work the same way with linked server.
I mean will the right INDEXES be used and so on?
Is it a good idea?
September 10, 2013 at 1:48 pm
It should not be a problem.
September 10, 2013 at 2:41 pm
No, it's not a good idea. SQL will typically not be able to generate as good a plan for remote tables as it does for local ones.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
September 10, 2013 at 2:51 pm
That's what I was suspecting Scott !
Thanks. Now I need to think how I explain it to our Lead....hmm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply