Row size of 8094

Question

Post reply

Row size of 8094

Andrew W

SSC Veteran

Points: 204
More actions
September 18, 2005 at 7:59 pm

#168366

Hi,
Does anyone know if the row size limit for character sorting on SQL Server 2005 is 8094 as it is in SQL Server 2000?
Thanks
Andrew.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135551 More actions · Answer 1

here's the test result :

Msg 8618, Level 16, State 2, Line 1

The query processor could not produce a query plan because a worktable is required, and its minimum row size exceeds the maximum allowable of 8060 bytes. A typical reason why a worktable is required is a GROUP BY or ORDER BY clause in the query. If the query has a GROUP BY or ORDER BY clause, consider reducing the number and/or size of the fields in the clause. Consider using prefix (LEFT()) or hash (CHECKSUM()) of fields for grouping or prefix for ordering. Note however that this will change the behavior of the query.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Andrew W SSC Veteran Points: 204 More actions · Answer 2

Thanks for that alzdba,

It seems that nothing has changed with regards to this then. Thanks for your time and effort with this, it is greatly appreciated.

Cheers,

Andrew.

Johan Bijnens SSC Guru Points: 135551 More actions · Answer 3

HTH