Find Currently Running Query – T-SQL

  • Sri8143

    SSCertifiable

    Points: 5251

    Comments posted to this topic are about the item Find Currently Running Query – T-SQL

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • ChrisM@Work

    SSC Guru

    Points: 186054

    This exact same query including comments word for word was published by Ian Stirk in 2009.

    http://www.sqlservercentral.com/articles/DMV/64425/

    [/url]

    Edit: 2008 even!

    [font="Arial"]“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw[/font]


    For fast, accurate and documented assistance in answering your questions, please read this article[/url].
    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]
    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]
    [url

  • Sri8143

    SSCertifiable

    Points: 5251

    I find the query useful so published it so that it might be useful for everyone. I was unaware of an existing post :-).

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply