Good afternoon,

I have a query (select from several table with an ORDER BY
clause) that is filling my tempdb as it generates message

Number = 1105, Severity = 17, State = 2, Line = 1, Message =
Can't allocate space for object 'temp worktable' in database
'tempdb' because 'system' segment is full/has no free
extents. If you ran out of space in syslogs, dump the
transaction log. Otherwise, use ALTER DATABASE to increase
the size of the segment.

My tempdb was 8Gbm we added an extra 8Gb but id didn't help.
Instead of increasing plus test, are there any way to
estimate the size of any temporary tables needed for a
query?

Thank you

--Simon