• CELKO:

    Unfortunately you have a TOP () operator. This proprietary and totally nonrelational operation requires a sort, hence the order by clause. Sorts are a killer in a relational system. You cannot do parallelization, map and reduce, or other modern optimizations.

    1) Please provide links to proof of any of those statements for SQL Server.

    2) STOP SPOUTING YOUR 30-YEAR-OLD KNOWLEDGE ABOUT NON-SQL-SERVER-STUFF ON THIS FORUM!!!!

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service