Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Peformance hit moving from 2005 to 2008?? RE: Peformance hit moving from 2005 to 2008??

  • August 27, 2015 at 9:43 pm

    #1822964

    jay-h (8/27/2015)

    updating...

    After we demonstrated that the db from the previous version was much faster on the same server, now suddenly, the vendor stopped saying "it must be your server" and started to admit that they did make some changes deep in the structure (the test queries are very difficult to follow manually because of security constructs, multiple layers of views with differing permissions and schemas--calls follow wildly differing paths depending on the account).

    the ball is now back in their court.

    I've had that happen many times and worked for a very short time for a company that used to pull those kinds of shenanigans. I cannot speak the actual words that I'm thinking without being banned from this forum. Real happy to see someone like yourself put a hammerlock on 3rd party know-it-alls like that. I especially like it because you used THEIR previous version to prove it. They just can't argue with that. Well done.

    --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)