• Sankar Reddy (7/15/2010)


    [font="Courier New"]I am glad this QoD has helped people learn new things. The credit should directly go to Hugo Kornelis for his excellent feedback otherwise this would have been an incorrect/ordinary question.[/font]

    Thanks for the kind words, Sankar. But you are giving me too much credit. The idea of the question was yours. I merely helped you to improve the options and the explanation a bit.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/