Solved

How to Increase the Key Size Limit of work table.

Posted on 1998-09-16
3
260 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
3 Comments
 

Author Comment

by:vssnmurthy
Comment Utility
Edited text of question
0
 
LVL 2

Expert Comment

by:odessa
Comment Utility
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
Comment Utility
In SQL server 6.5  composite index can not exceed 900 bytes. It is can not be changed.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
CREATE DATABASE ENCRYPTION KEY 1 41
Sql Stored Procedure 26 27
combine an MS SQL string in Idera DM 9 27
Sql query 34 16
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…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

772 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now