• Koen Verbeeck (4/16/2014)


    Since profiler is deprecated and to be fully replaced with Extended Events, you can be fairly certain it is possible with Extended Events as well.

    We're still stuck on 2005 at work (hopefully migrating to 2014 in late summer) so I've not had the joy of playing with Extended Events in a production environment but it always scares the hell out of me when old tried'n'true methods are replaced because they seem to always leave something out. Things like the {f4} key in old Query Analyzer didn't make it into SSMS and it was some really helpful and easy to use functionality when you really needed it.

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