Home Forums SQL Server 2014 Development - SQL Server 2014 Query plan for partitioned views not running as they should. RE: Query plan for partitioned views not running as they should.

  • March 30, 2015 at 10:39 am

    #1787422

    josjonkmans (3/30/2015)

    I did find a solution for the problem, I was using an SQL account for my linkedserver connections. When I changed it to use the "Be made using the current security context" option and setting up the manual spn (because I'm running the services under domain accounts) it is running correctly. This seems to fix the problem, still finding it strange that the query plans get messed up when changing the security context for the linked servers.

    Thank you for the feedback on this. Privs are one of the things that a lot of people, present company included, sometimes forget about when it comes to such things.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)