Hello @Serverless SQL ,
Thanks for the question and using MS Q&A platform.
Yes, there is a total size is limited to 100MB in temporary tables in serverless SQL pool.
For more details, refer to Temporary tables in serverless SQL pool.
Hope this helps. Do let us know if you any further queries.
---------------------------------------------------------------------------
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.