I have a SQL statement based on 'Group By' Clause and 'Order By' . When I run this query I get this error message
"The current query would generate a key size of 1012 for a work table. This exceeds the maximum allowable limit of 900"
I know that SQL Server creates a work table for GROUP by clauses internally.
How to increase the Key size of that table.