• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

How to Increase the Key Size Limit of work table.

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.

0
vssnmurthy
Asked:
vssnmurthy
1 Solution
 
vssnmurthyAuthor Commented:
Edited text of question
0
 
odessaCommented:
try to change 'sort pages' in SQL Server configuration or
do
exec sp_configure 'sort pages', SOME (e.g. 100)

0
 
Victor SpiridonovCommented:
In SQL server 6.5  composite index can not exceed 900 bytes. It is can not be changed.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now