Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dave62 Number of Rows RE: Number of Rows

  • January 18, 2013 at 6:38 am

    #1578689

    mtassin (1/18/2013)

    Koen Verbeeck (1/18/2013)

    Always hard to answer a question with no documented behaviour without running it 😉

    You can still get it wrong like I did...

    SQL 2008R2 RTM - No rows affected

    SQL 2008R2 SP1 - No rows affected

    SQL 2012 RTM - No rows affected

    Don't have a 2008 SP3 instance to test on.

    Aaah never mind... missed the whole estimated execution plan, which would have been the plan itself... duh.


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]