Home Forums SQL Server 2005 SQL Server 2005 General Discussion How to Write Query for the Below Requirement? RE: How to Write Query for the Below Requirement?

  • September 23, 2013 at 10:33 am

    #1652407

    wolfkillj (9/23/2013)

    And duh, of course you can see the number of executions of a node in an execution plan displayed as Number of Executions in the Properties that pop up when you hover over the node. No need to scrutinize the XML - I just like to dig through it sometimes because you can find things there that you can't see in SSMS's graphical display.

    Thanks for the reminder. I never looked beneath the surface of the execution plan to see the actual number of executions.

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/