Post reply

How we can increase Row Size limit for Order By

  • March 31, 2009 at 4:11 am

    #130163

    There is size limit of 8060 bytes for shorting of a row in Order By clause, but how we can increase size to desired limit. So SQL Server will not through any error during such processing. I want to increase this size limit to 9000 bytes.

  • March 31, 2009 at 5:06 am

    #968967

    You can't. That's a hard limit built into the system. That's a lot of data to be sorting on. Do you have any options there? What are you trying to do?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 31, 2009 at 5:10 am

    #968969

    I don't think one can change the limit of 8060 for ORDER BY clause because SQL Server internally creates intermediate work tables to do the sort operations.

    The following article lists the Maximum Capacity Specifications for SQL Server

    --Ramesh

Viewing 3 posts - 1 through 2 (of 2 total)

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