Solved

How to Increase the Key Size Limit of work table.

Posted on 1998-09-16
3
276 Views
Last Modified: 2010-05-18
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
Comment
Question by:vssnmurthy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 

Author Comment

by:vssnmurthy
ID: 1090090
Edited text of question
0
 
LVL 2

Expert Comment

by:odessa
ID: 1090091
try to change 'sort pages' in SQL Server configuration or
do
exec sp_configure 'sort pages', SOME (e.g. 100)

0
 
LVL 7

Accepted Solution

by:
spiridonov earned 100 total points
ID: 1090092
In SQL server 6.5  composite index can not exceed 900 bytes. It is can not be changed.
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question