Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dr_seusse
Starting Member
22 Posts |
 Posted - 2002-07-19 : 16:58:26
|
Has anyone encountered this problem before?"Cannot sort a row of size 8210, which is greater than the allowable maximum of 8094."What can I do. I'm doing a search that sorts by hits, so I HAVE to sort the recordsets. Even when I commented out the "order by hits", this error message still occurs. Is this where the error is being generated?In addition, this search involves the "sequence" table which has 8000 rows...could this be the source of the error?doc needs help!  ----exert of code:SELECT *, count(*) hits FROM SEQUENCE WHERE .... Group by.... ORDER BY Hits DESC |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-07-19 : 17:50:29
|
| do you have any TEXT fields in that select statement?Michael<Yoda>Use the Search page you must. Find the answer you will. |
 |
|
|
dr_seusse
Starting Member
22 Posts |
Posted - 2002-07-22 : 09:04:35
|
Hi MichaelPWhat do you mean by a "TEXT" field? Well the vw1.Info column consists of a maximum of 7500 varchar characters, where I do a keyword search through this column (via the 'sequence' table).my code is below.Thanks  SELECT ID, Name, count(*) hits FROM SEQUENCE INNER JOIN vw1 ON vw1.Info like '%' + Substring(' ' + @Location + ' ',seq, CharIndex(' ' , ' ' + @Location + ' ' , seq) - seq) + '%' WHERE seq <= len(' ' + @Location + ' ') and Substring(' ' + @Location + ' ', seq - 1, 1) = ' ' and CharIndex(' ' , ' ' + @Location + ' ' , seq) - seq > 0 Group by ID, Name ORDER BY Hits DESC |
|
|
|
dr_seusse
Starting Member
22 Posts |
Posted - 2002-07-22 : 09:53:21
|
furthermore...i have ~700 entries in vw1once I 'select top 50 percent', the function works again.Is there a way to beef up my database somewhere/somehow?medical prescription required... ...not morphine, just SQL tips |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-07-23 : 19:49:26
|
| If you do SELECT TOP 100 PERCENT... does it work?I have to admit I'm having trouble getting past the error message that you have a row size of 8210. I'm guessing this is the total potential row size (i.e. if you add up all the maximum sizes of your fields it = 8210). You can't (I think) actually populate a table with more than 8060 characters of data even though you can define a table with varchars that theoretically would exceed that level. I'm guessing this is the problem you have. Although, if it is, I don't know why SELECT TOP 50 PERCENT... would work. |
|
|
|
|
|
|
|
|
rows overflowed (not sorting) !!!