<p>Came across this error today. Wondering if anyone can tell me what it means:</p>

<blockquote>
  <blockquote>
    <p>Cannot sort a row of size 9522, which is greater than the allowable maximum of 8094.</p>
  </blockquote>
</blockquote>

<p>Is that 8094 bytes? Characters? Fields? Is this a problem joining multiple tables that are exceeding some limit?</p>

[{'answer_id': 16794, 'author': 'AndyMan', 'author_id': 1956, 'author_profile': 'https://Stackoverflow.com/users/1956', 'pm_score': 0, 'selected': False, 'text': '<p>That used to be a problem in SQL 2000, but I thought that was fixed in 2005.</p>\n'}, {'answer_id': 16799, 'author': 'Redbaron', 'author_id': 41, 'author_profile': 'https://Stackoverflow.com/users/41', 'pm_score': 0, 'selected': False, 'text': '<p>8094 bytes.</p>\n\n<p>If you list some more information about what you are doing it might help us to figure out the actual cause. </p>\n'}, {'answer_id': 16806, 'author': 'JeremiahClark', 'author_id': 581, 'author_profile': 'https://Stackoverflow.com/users/581', 'pm_score': 4, 'selected': True, 'text': '<p>In SQL 2000, the row limit is 8K bytes, which is the same size as a page in memory. </p>\n\n<p>[Edit]</p>\n\n<p>In 2005, the page size is the same (8K), but the database uses pointers on the row in the page to point to other pages that contain larger fields.  This allows 2005 to overcome the 8K row size limitation.</p>\n'}, {'answer_id': 16895, 'author': 'Kibbee', 'author_id': 1862, 'author_profile': 'https://Stackoverflow.com/users/1862', 'pm_score': 3, 'selected': False, 'text': "<p>The problem that seems to catch a lot of people, is that you can create a table that by definition would hold more than 8K of data, and it will accept it just fine.  And the table will work fine, up until the point you actually try to insert more than 8K of data into the table.  </p>\n\n<p>So, let's say you create a table with an integer field, for the primary key, and 10 varchar(1000) fields.  The table would work fine most of the time, as the number of times you would fill up all 10 of your varchar(1000) fields would be very few.  Howerver, in the even that you tried to put 1000 characters in each of your fields, it would give you the error mentioned in this question.</p>\n"}, {'answer_id': 2547872, 'author': 'Kevin Albrecht', 'author_id': 10475, 'author_profile': 'https://Stackoverflow.com/users/10475', 'pm_score': 2, 'selected': False, 'text': '<p>FYI, running this SQL command on your DB can fix the problem if it is caused by space that needs to be reclaimed after dropping variable length columns:</p>\n\n<pre><code>DBCC CLEANTABLE (0,[dbo.TableName])\n</code></pre>\n\n<p>See: <a href="http://msdn.microsoft.com/en-us/library/ms174418.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/ms174418.aspx</a></p>\n'}]
['https://Stackoverflow.com/questions/16792', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1975282/']