• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • 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.

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

Victor SpiridonovCommented:
In SQL server 6.5  composite index can not exceed 900 bytes. It is can not be changed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

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