Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning ORMs and Indexes with Included Columns RE: ORMs and Indexes with Included Columns

  • December 8, 2012 at 10:48 pm

    #1566861

    LightningFingers (12/2/2010)

    I agree. You should never assume that any optimization has actually optimized anything until you test it. Testing L2S is a pain in the *** because you basically need to use profiler to pull out the generated SQL and then run it manually to see the execution plan. Which I will do, it's just not fun.

    A true "King Among Men" is defined as being absolutely awesome in everything done.

    So no, I'm not about to swear fealty. But you rock!

    Heh... despite her avatar, GilaMonster is Gail Shaw. She's not only a lady, but a very smart lady that has tested out on and earned the MCM in SQL Server.

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