41399

Product Name

Event ID

41399

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

MAX_SORT_ROW_WIDTH_EXCEEDED

Message Text

The sort operation is too complex. Consult SQL Server Books Online for more

information.

Sorting the result of join and aggregation operations increases the complexity of the sort

operation by increasing the size of the row in the sort buffer. This error means that the size of

the row is larger than the maximum size supported by the sort operator in natively compiled

stored procedures. Note that the size of a row in the sort buffer is determined solely by the

number of joins and the number and type of aggregate functions. The size of the rows in the

base tables does not affect the size of the row in the buffer.

Decrease the complexity of the query by removing joins or aggregate functions.

In-Memory OLTP (In-Memory Optimization)

ﾉ

Expand table